DBA Data[Home] [Help]

APPS.CSTPIDIC dependencies on CST_ITEM_COST_DETAILS

Line 91: from cst_item_cost_details

87: /* Insert into CICD only if no rows exist now. */
88: p_location := 5;
89: select count(*)
90: into p_dummy
91: from cst_item_cost_details
92: where inventory_item_id = I_INVENTORY_ITEM_ID
93: AND organization_id = I_ORGANIZATION_ID
94: AND cost_type_id = I_COST_TYPE_ID;
95:

Line 97: /* Create a TL matl cost row in CST_ITEM_COST_DETAILS */

93: AND organization_id = I_ORGANIZATION_ID
94: AND cost_type_id = I_COST_TYPE_ID;
95:
96: p_location := 6;
97: /* Create a TL matl cost row in CST_ITEM_COST_DETAILS */
98: IF p_dummy = 0 THEN
99: INSERT INTO CST_ITEM_COST_DETAILS
100: ( INVENTORY_ITEM_ID,
101: ORGANIZATION_ID,

Line 99: INSERT INTO CST_ITEM_COST_DETAILS

95:
96: p_location := 6;
97: /* Create a TL matl cost row in CST_ITEM_COST_DETAILS */
98: IF p_dummy = 0 THEN
99: INSERT INTO CST_ITEM_COST_DETAILS
100: ( INVENTORY_ITEM_ID,
101: ORGANIZATION_ID,
102: COST_TYPE_ID,
103: LAST_UPDATE_DATE,