APPS.CSTPSCCM dependencies on CST_SC_SOURCING_RULES

Line 65: CST_SC_SOURCING_RULES CSSR,

61: cssr.ship_charge,
62: cssr.conversion_rate,
63: cssr.ship_method
64: FROM
65: CST_SC_SOURCING_RULES CSSR,
66: MTL_SYSTEM_ITEMS MSI,
67: BOM_PARAMETERS BP
68: WHERE
69: CSSR.ROLLUP_ID = l_rollup_id

Line 91: CST_SC_SOURCING_RULES CSSR

87: vendor_site_id,
88: item_cost,
89: buy_cost_flag
90: FROM
91: CST_SC_SOURCING_RULES CSSR
92: WHERE
93: CSSR.ROLLUP_ID = l_rollup_id
94: AND CSSR.inventory_item_id = l_inventory_item_id
95: AND CSSR.organization_id = l_dest_organization_id

Line 185: CST_SC_SOURCING_RULES CSSC

181: SUM(allocation_percent)/100
182: INTO
183: curr_org_make_weight
184: FROM
185: CST_SC_SOURCING_RULES CSSC
186: WHERE
187: CSSC.rollup_id = p_rollup_id
188: AND CSSC.assignment_set_id = p_assignment_set_id
189: AND CSSC.inventory_item_id = p_inventory_item_id

Line 210: FROM CST_SC_SOURCING_RULES CSSR

206:
207:
208: SELECT count(1)
209: INTO l_count_src_rows
210: FROM CST_SC_SOURCING_RULES CSSR
211: WHERE CSSR.rollup_id = p_rollup_id
212: AND CSSR.assignment_set_id = p_assignment_set_id
213: AND CSSR.inventory_item_id = p_inventory_item_id
214: AND CSSR.organization_id = p_dest_organization_id

Line 269: CST_SC_SOURCING_RULES CSSC

265: NVL(allocation_percent,0)/100
266: INTO
267: curr_vendor_buy_weight
268: FROM
269: CST_SC_SOURCING_RULES CSSC
270: WHERE
271: CSSC.ROWID = vendor_cur.ROWID;
272:
273:

Line 374: CST_SC_SOURCING_RULES CSSR

370: NVL(vendor_cur.vendor_id, -1), -- SCAPI: use -1 if no vendor name
371: NVL(vendor_cur.vendor_site_id, -1),
372: curr_vendor_buy_weight*100
373: FROM
374: CST_SC_SOURCING_RULES CSSR
375: WHERE
376: CSSR.organization_id = p_dest_organization_id AND
377: CSSR.inventory_item_id = p_inventory_item_id AND
378: UPPER(vendor_cur.buy_cost_flag) = 'Y' AND

Line 904: DELETE CST_SC_SOURCING_RULES CSSR

900: AND CSBE1.COMPONENT_ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);
901:
902: l_stmt_num := 30;
903:
904: DELETE CST_SC_SOURCING_RULES CSSR
905: WHERE CSSR.ROLLUP_ID IN (
906: SELECT CSRH.ROLLUP_ID
907: FROM CST_SC_ROLLUP_HISTORY CSRH
908: WHERE CSRH.ROLLUP_ID <> p_rollup_id

Line 915: FROM CST_SC_SOURCING_RULES CSSR1,

911: CSSR.ORGANIZATION_ID)
912: IN
913: (SELECT CSSR1.INVENTORY_ITEM_ID,
914: CSSR1.ORGANIZATION_ID
915: FROM CST_SC_SOURCING_RULES CSSR1,
916: CST_SC_LOW_LEVEL_CODES CSLLC
917: WHERE CSSR1.ROLLUP_ID = p_rollup_id
918: AND CSSR1.ROLLUP_ID = CSLLC.ROLLUP_ID
919: AND CSSR1.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID