DBA Data[Home] [Help]

APPS.CSTPUPDT dependencies on CST_ITEM_LIST_TEMP

Line 444: CST_ITEM_LIST_TEMP CLT

440: CURSOR CILT_CUR is
441: SELECT CIC1.inventory_item_id
442: FROM CST_ITEM_COSTS CIC1,
443: CST_ITEM_COSTS CIC2,
444: CST_ITEM_LIST_TEMP CLT
445: WHERE CIC1.organization_id = l_org_id
446: AND CIC1.cost_type_id = b_cm_frozen_standard
447: AND CIC1.inventory_item_id = CLT.inventory_item_id
448: AND CIC2.organization_id (+) = l_org_id

Line 527: DELETE FROM CST_ITEM_LIST_TEMP CILT

523: l_stmt_num := 20;
524:
525: FORALL i IN cilt_item_id.first..cilt_item_id.last
526:
527: DELETE FROM CST_ITEM_LIST_TEMP CILT
528: WHERE inventory_item_id=cilt_item_id(i);
529:
530: EXIT WHEN CILT_CUR%NOTFOUND;
531: END LOOP;