DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 2335: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL

2331: END IF;
2332:
2333: /* Bug 5373370 - Start */
2334: SELECT
2335: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL
2336: INTO
2337: l_dist_interface_header_id
2338: FROM DUAL;
2339:

Line 2351: INSERT INTO po_distributions_interface

2347:
2348: /* Bug 5373370 - End */
2349:
2350:
2351: INSERT INTO po_distributions_interface
2352: ( interface_header_id
2353: , interface_line_id
2354: , interface_distribution_id
2355: , quantity_ordered

Line 2407: PO_DISTRIBUTIONS_INTERFACE is inserted into MCT. This column

2403:
2404:
2405: /* Bug 5373370 - Start */
2406: /* The distribution_interface_ref that is inserted into
2407: PO_DISTRIBUTIONS_INTERFACE is inserted into MCT. This column
2408: will later be joined to PO_DISTRIBUTIONS_ALL to fetch the
2409: PO_DISTRIBUTION_ID */
2410:
2411: /* MMT no longer used in this query */