[Home] [Help]
463: -- if the profile option po_autocreate_date is set to req gl date
464: -- use req's gl date to build encum gl date, otherwise use sysdate.
465: GET_GL_PERIOD_NAME,
466: GET_GL_DATE(
467: DECODE( FND_PROFILE.VALUE('PO_AUTOCREATE_DATE')
468: , 'REQ GL DATE', PRD.GL_ENCUMBERED_DATE
469: , TRUNC(SYSDATE) ), L_SOB),
470: --L_PERIOD_NAME,
471: -1, --PDI.DISTRIBUTION_NUM,
698: -- if the profile option po_autocreate_date is set to req gl date
699: -- use req's gl date to build encum gl date, otherwise use sysdate.
700: GET_GL_PERIOD_NAME,
701: GET_GL_DATE(
702: DECODE( FND_PROFILE.VALUE('PO_AUTOCREATE_DATE')
703: , 'REQ GL DATE', PRD.GL_ENCUMBERED_DATE
704: , TRUNC(SYSDATE) ), L_SOB),
705: --L_PERIOD_NAME,
706: -1, --PDI.DISTRIBUTION_NUM,
914: D_POSITION := 225;
915: DEBUG(D_MODULE, D_POSITION, 'UPDATING THE NEW GT TABLE FOR AMOUNT ORDERED AND QUANTITY ORDERED');
916: -- Update the Amount_ordered, Quantity_ordered based on Line type.
917: UPDATE PO_DISTRIBUTIONS_GT GT
918: SET QUANTITY_ORDERED = (SELECT DECODE(POL.MATCHING_BASIS, 'AMOUNT', NULL, Trunc((NVL(GT.AMOUNT_ORDERED,0) / POL.PRICE_OVERRIDE),Nvl(FND_PROFILE.VALUE('PO_QUANTITY_PRECISION'),5)) )
919: FROM PO_LINE_LOCATIONS_MERGE_V POL
920: WHERE GT.LINE_LOCATION_ID = POL.LINE_LOCATION_ID
921: AND GT.DRAFT_ID = POL.DRAFT_ID),
922: AMOUNT_ORDERED = (SELECT DECODE(POL.MATCHING_BASIS, 'AMOUNT', AMOUNT_ORDERED, NULL)