eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPUMEC dependencies on CST_LISTS

Line 33: FROM cst_lists CL

29: WHERE CIC.organization_id = I_ORGANIZATION_ID
30: AND CIC.cost_type_id = I_COST_TYPE_ID
31: AND CIC.inventory_item_id in
32: (SELECT C2.inventory_item_id
33: FROM cst_lists CL
34: , cst_item_costs C2
35: WHERE list_id = I_LIST_ID
36: AND C2.cost_type_id = I_FROM_COST_TYPE
37: AND C2.organization_id = I_ORGANIZATION_ID

Line 124: FROM cst_lists CL

120: , CIC.attribute12
121: , CIC.attribute13
122: , CIC.attribute14
123: , CIC.attribute15
124: FROM cst_lists CL
125: , cst_item_costs CIC
126: WHERE CL.list_id = I_LIST_ID
127: AND CIC.inventory_item_id = CL.entity_id
128: AND CIC.cost_type_id = I_FROM_COST_TYPE

Line 142: FROM cst_lists CL

138: WHERE CICD.organization_id = I_ORGANIZATION_ID
139: AND CICD.cost_type_id = I_COST_TYPE_ID
140: AND CICD.inventory_item_id in
141: (SELECT C2.inventory_item_id
142: FROM cst_lists CL
143: , cst_item_costs C2
144: WHERE list_id = I_LIST_ID
145: AND C2.cost_type_id = I_FROM_COST_TYPE
146: AND C2.organization_id = I_ORGANIZATION_ID

Line 255: FROM cst_lists CL

251: , CICD.attribute12
252: , CICD.attribute13
253: , CICD.attribute14
254: , CICD.attribute15
255: FROM cst_lists CL
256: , cst_item_cost_details CICD
257: WHERE CL.list_id = I_LIST_ID
258: AND CICD.cost_type_id = I_FROM_COST_TYPE
259: AND CICD.organization_id = I_ORGANIZATION_ID

Line 294: from cst_lists l

290: TYPE l_table IS TABLE OF CST_ITEM_COSTS.INVENTORY_ITEM_ID%TYPE;
291: l_temp_table l_table;
292: CURSOR cur_list IS
293: (select entity_id
294: from cst_lists l
295: where L.list_id = I_LIST_ID
296: and NOT EXISTS (select inventory_item_id
297: from cst_item_costs cic2
298: where cic2.inventory_item_id = l.entity_id

Line 479: FROM cst_lists L

475: , CIC.attribute12
476: , CIC.attribute13
477: , CIC.attribute14
478: , CIC.attribute15
479: FROM cst_lists L
480: , cst_item_costs CIC
481: , bom_resources BR
482: WHERE CIC.organization_id = I_ORGANIZATION_ID
483: AND L.list_id = I_LIST_ID

Line 537: FROM cst_lists cl

533: /* Cursor UPD_ITEM_ID modified for bug 1970016 , 2592136 */
534:
535: Cursor UPD_ITEM_ID is
536: SELECT entity_id
537: FROM cst_lists cl
538: WHERE CL.list_id= I_LIST_ID
539: AND EXISTS (SELECT /*+ no_unnest index( cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
540: NULL FROM
541: CST_ITEM_COST_DETAILS CICD

Line 552: select entity_id from cst_lists cl

548:
549:
550: /* Modified the cursor for Bug 5150357 */
551: Cursor C_ITEM_ID is
552: select entity_id from cst_lists cl
553: where list_id = I_LIST_ID
554: AND EXISTS (SELECT /*+ no_unnest index( cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
555: NULL FROM
556: CST_ITEM_COST_DETAILS CICD

Line 561: TYPE c_item_id_tbl_type IS TABLE OF cst_lists.entity_id%TYPE INDEX BY BINARY_INTEGER;

557: WHERE CICD.organization_id = I_ORGANIZATION_ID
558: AND CICD.cost_type_id = I_COST_TYPE_ID
559: AND CL.entity_id = CICD.inventory_item_id);
560:
561: TYPE c_item_id_tbl_type IS TABLE OF cst_lists.entity_id%TYPE INDEX BY BINARY_INTEGER;
562: c_item_id_tbl c_item_id_tbl_type;
563:
564: l_location NUMBER;
565: