The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL. You used a Do Select action to select QTY_ON_HAND, QTY_ORDERED, and ITEM_CD from PS_PSU_ORDER_DTL into the state record. You added a SQL action to update PS_PSU_STOCK_TBL…

View the Exhibit, which displays your file layout for a purchase order. In your application engine program to export the data to a file, which statement will instantiate the rowset? A. &rowset=CreateRowset(Record.PSU_PO_HDR),CreateRowset(Record.PSU_PO_DTL); B. &rowset=CreateRowset(Record.PSU_PO_HDR,CreateRowset(Record.PSU_PO_DTL)); C. &rowset1=CreateRowset(Record.PSU_PO_HDR);&rowset2=CreateRowset(Record.PSU_PO_DTL); D. &MYFILE.SetFileLayout(FileLayout.PO_FILE); E. &MYFILE…

You created a component interface based on a component that has a parent and one non-effective-dated child (Level 0 and 1). You have been asked to write the PeopleCode to insert a new row in the collection if the row…

Examine this PeopleCode snippet: &SQL = CreateSQL("Select %EffDtCheck(EFFDT) from %Table(PSU_INSTR_TBL)"); Select the correct option. A. The statement is valid. B. The statement is not valid. The correct syntax is: &SQL = CreateSQL("Select %DateIn(EFFDT) from %Table(PSU_INSTR_TBL)"); C. The statement is not…