DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 2048: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL

2044: END IF;
2045:
2046: /* Bug 5373370 - Start */
2047: SELECT
2048: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL
2049: INTO
2050: l_dist_interface_header_id
2051: FROM DUAL;
2052:

Line 2064: INSERT INTO po_distributions_interface

2060:
2061: /* Bug 5373370 - End */
2062:
2063:
2064: INSERT INTO po_distributions_interface
2065: ( interface_header_id
2066: , interface_line_id
2067: , interface_distribution_id
2068: , quantity_ordered

Line 2120: PO_DISTRIBUTIONS_INTERFACE is inserted into MCT. This column

2116:
2117:
2118: /* Bug 5373370 - Start */
2119: /* The distribution_interface_ref that is inserted into
2120: PO_DISTRIBUTIONS_INTERFACE is inserted into MCT. This column
2121: will later be joined to PO_DISTRIBUTIONS_ALL to fetch the
2122: PO_DISTRIBUTION_ID */
2123:
2124: /* MMT no longer used in this query */