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.CST_INVENTORY_PVT dependencies on CST_ITEM_LIST_TEMP

Line 123: INSERT INTO cst_item_list_temp(

119: p_cost_type_id IS NULL AND
120: l_def_cost_type_id = l_primary_cost_method
121: THEN
122:
123: INSERT INTO cst_item_list_temp(
124: inventory_item_id,
125: category_id,
126: cost_type_id
127: )

Line 165: INSERT INTO cst_item_list_temp(

161: ELSE
162: --}
163: log( 'Herve s call2') ;
164:
165: INSERT INTO cst_item_list_temp(
166: inventory_item_id,
167: category_id,
168: cost_type_id
169: )

Line 214: INTO cst_item_list_temp(

210: log( 'Herve s call3') ;
211:
212:
213: INSERT
214: INTO cst_item_list_temp(
215: inventory_item_id,
216: category_id,
217: cost_type_id
218: )

Line 265: INTO cst_item_list_temp(

261:
262: ELSE
263:
264: INSERT
265: INTO cst_item_list_temp(
266: inventory_item_id,
267: category_id,
268: cost_type_id
269: )

Line 328: INTO cst_item_list_temp(

324: -- because non-costing-enabled items are not excluded from the report.
325: -- The p_zero_cost_only and p_expense_item parameters are also ignored.
326: l_stmt_num := 30;
327: INSERT
328: INTO cst_item_list_temp(
329: inventory_item_id,
330: category_id,
331: cost_type_id
332: )

Line 365: INTO cst_item_list_temp(

361: END IF;
362:
363: IF p_one_time_item = 1 THEN
364: INSERT
365: INTO cst_item_list_temp(
366: inventory_item_id,
367: category_id,
368: cost_type_id
369: )

Line 739: cst_item_list_temp CILT,

735: DECODE(p_qty_by_revision,1,moq.revision,NULL),
736: CILT.category_id,
737: CILT.cost_type_id
738: FROM mtl_onhand_quantities MOQ,
739: cst_item_list_temp CILT,
740: cst_cg_list_temp CCLT,
741: cst_sub_list_temp CSLT
742: WHERE MOQ.organization_id = p_organization_id
743: AND CILT.inventory_item_id = MOQ.inventory_item_id

Line 794: cst_item_list_temp CILT,

790: MMT.transaction_source_type_id,
791: CILT.category_id,
792: CILT.cost_type_id
793: FROM mtl_material_transactions MMT,
794: cst_item_list_temp CILT,
795: cst_cg_list_temp CCLT,
796: cst_sub_list_temp CSLT
797: WHERE MMT.organization_id = p_organization_id
798: AND CILT.inventory_item_id = MMT.inventory_item_id

Line 875: cst_item_list_temp CILT

871: MMT.transaction_source_type_id,
872: CILT.category_id,
873: CILT.cost_type_id
874: FROM mtl_material_transactions MMT,
875: cst_item_list_temp CILT
876: WHERE MMT.organization_id = p_organization_id
877: AND CILT.inventory_item_id = MMT.inventory_item_id
878: AND MMT.costed_flag IS NULL
879: AND MMT.transaction_date > p_valuation_date

Line 959: FROM cst_item_list_temp

955: FROM (
956: SELECT inventory_item_id,
957: category_id,
958: cost_type_id
959: FROM cst_item_list_temp
960: MINUS
961: SELECT DISTINCT
962: inventory_item_id,
963: category_id,

Line 1150: cst_item_list_temp ITEMS,

1146: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
1147: ),
1148: MS.shipment_line_id
1149: FROM mtl_supply MS,
1150: cst_item_list_temp ITEMS,
1151: cst_cg_list_temp CGS,
1152: mtl_parameters MP,
1153: mtl_interorg_parameters MIP,
1154: mtl_material_transactions MMT,

Line 1253: cst_item_list_temp ITEMS,

1249: ),
1250: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1251: RSL.shipment_line_id
1252: FROM mtl_material_transactions MMT,
1253: cst_item_list_temp ITEMS,
1254: cst_cg_list_temp CGS,
1255: mtl_interorg_parameters MIP,
1256: mtl_system_items MSI_TO,
1257: rcv_shipment_headers RSH,

Line 1349: cst_item_list_temp ITEMS,

1345: ),
1346: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1347: RT.shipment_line_id
1348: FROM mtl_material_transactions MMT,
1349: cst_item_list_temp ITEMS,
1350: cst_cg_list_temp CGS,
1351: mtl_interorg_parameters MIP,
1352: mtl_system_items MSI_FROM,
1353: rcv_transactions RT

Line 1450: cst_item_list_temp ITEMS,

1446: ),
1447: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1448: RSL.shipment_line_id
1449: FROM mtl_material_transactions MMT,
1450: cst_item_list_temp ITEMS,
1451: cst_cg_list_temp CGS,
1452: mtl_interorg_parameters MIP,
1453: mtl_system_items MSI_TO,
1454: rcv_shipment_headers RSH,

Line 1551: cst_item_list_temp ITEMS,

1547: ),
1548: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1549: RT.shipment_line_id
1550: FROM mtl_material_transactions MMT,
1551: cst_item_list_temp ITEMS,
1552: cst_cg_list_temp CGS,
1553: mtl_interorg_parameters MIP,
1554: mtl_system_items MSI_FROM,
1555: rcv_transactions RT

Line 1650: cst_item_list_temp ITEMS,

1646: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
1647: ),
1648: MS.shipment_line_id
1649: FROM mtl_supply MS,
1650: cst_item_list_temp ITEMS,
1651: cst_cg_list_temp CGS,
1652: mtl_parameters MP,
1653: mtl_interorg_parameters MIP,
1654: mtl_material_transactions MMT,

Line 1756: cst_item_list_temp ITEMS,

1752: ),
1753: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1754: RSL.shipment_line_id
1755: FROM mtl_material_transactions MMT,
1756: cst_item_list_temp ITEMS,
1757: cst_cg_list_temp CGS,
1758: mtl_interorg_parameters MIP,
1759: mtl_system_items MSI_TO,
1760: rcv_shipment_headers RSH,

Line 1856: cst_item_list_temp ITEMS,

1852: ),
1853: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1854: RT.shipment_line_id
1855: FROM mtl_material_transactions MMT,
1856: cst_item_list_temp ITEMS,
1857: cst_cg_list_temp CGS,
1858: mtl_interorg_parameters MIP,
1859: mtl_system_items MSI_FROM,
1860: rcv_transactions RT

Line 1957: cst_item_list_temp ITEMS,

1953: ),
1954: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1955: RSL.shipment_line_id
1956: FROM mtl_material_transactions MMT,
1957: cst_item_list_temp ITEMS,
1958: cst_cg_list_temp CGS,
1959: mtl_interorg_parameters MIP,
1960: mtl_system_items MSI_TO,
1961: rcv_shipment_headers RSH,

Line 2058: cst_item_list_temp ITEMS,

2054: ),
2055: NVL(MMT.intransit_account, MIP.intransit_inv_account),
2056: RT.shipment_line_id
2057: FROM mtl_material_transactions MMT,
2058: cst_item_list_temp ITEMS,
2059: cst_cg_list_temp CGS,
2060: mtl_interorg_parameters MIP,
2061: mtl_system_items MSI_FROM,
2062: rcv_transactions RT

Line 2162: cst_item_list_temp ITEMS,

2158: MMT.intransit_account,
2159: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
2160: )
2161: FROM mtl_supply MS,
2162: cst_item_list_temp ITEMS,
2163: cst_cg_list_temp CGS,
2164: mtl_parameters MP,
2165: mtl_interorg_parameters MIP,
2166: mtl_material_transactions MMT,

Line 2260: cst_item_list_temp ITEMS,

2256: )
2257: ),
2258: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2259: FROM mtl_material_transactions MMT,
2260: cst_item_list_temp ITEMS,
2261: cst_cg_list_temp CGS,
2262: mtl_interorg_parameters MIP,
2263: mtl_system_items MSI_TO
2264: WHERE MMT.transfer_organization_id = p_organization_id

Line 2348: cst_item_list_temp ITEMS,

2344: )
2345: ),
2346: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2347: FROM mtl_material_transactions MMT,
2348: cst_item_list_temp ITEMS,
2349: cst_cg_list_temp CGS,
2350: mtl_interorg_parameters MIP,
2351: mtl_system_items MSI_FROM
2352: WHERE MMT.organization_id = p_organization_id

Line 2444: cst_item_list_temp ITEMS,

2440: )
2441: ),
2442: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2443: FROM mtl_material_transactions MMT,
2444: cst_item_list_temp ITEMS,
2445: cst_cg_list_temp CGS,
2446: mtl_interorg_parameters MIP,
2447: mtl_system_items MSI_TO,
2448: mtl_transaction_types MTT

Line 2541: cst_item_list_temp ITEMS,

2537: )
2538: ),
2539: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2540: FROM mtl_material_transactions MMT,
2541: cst_item_list_temp ITEMS,
2542: cst_cg_list_temp CGS,
2543: mtl_interorg_parameters MIP,
2544: mtl_system_items MSI_FROM,
2545: mtl_transaction_types MTT

Line 2639: cst_item_list_temp ITEMS,

2635: MMT.intransit_account,
2636: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
2637: )
2638: FROM mtl_supply MS,
2639: cst_item_list_temp ITEMS,
2640: cst_cg_list_temp CGS,
2641: mtl_parameters MP,
2642: mtl_interorg_parameters MIP,
2643: mtl_material_transactions MMT,

Line 2740: cst_item_list_temp ITEMS,

2736: )
2737: ),
2738: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2739: FROM mtl_material_transactions MMT,
2740: cst_item_list_temp ITEMS,
2741: cst_cg_list_temp CGS,
2742: mtl_interorg_parameters MIP,
2743: mtl_system_items MSI_TO
2744: WHERE MMT.organization_id = p_organization_id

Line 2832: cst_item_list_temp ITEMS,

2828: )
2829: ),
2830: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2831: FROM mtl_material_transactions MMT,
2832: cst_item_list_temp ITEMS,
2833: cst_cg_list_temp CGS,
2834: mtl_interorg_parameters MIP,
2835: mtl_system_items MSI_FROM
2836: WHERE MMT.transfer_organization_id = p_organization_id

Line 2928: cst_item_list_temp ITEMS,

2924: )
2925: ),
2926: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2927: FROM mtl_material_transactions MMT,
2928: cst_item_list_temp ITEMS,
2929: cst_cg_list_temp CGS,
2930: mtl_interorg_parameters MIP,
2931: mtl_system_items MSI_TO,
2932: mtl_transaction_types MTT

Line 3025: cst_item_list_temp ITEMS,

3021: )
3022: ),
3023: NVL(MMT.intransit_account, MIP.intransit_inv_account)
3024: FROM mtl_material_transactions MMT,
3025: cst_item_list_temp ITEMS,
3026: cst_cg_list_temp CGS,
3027: mtl_interorg_parameters MIP,
3028: mtl_system_items MSI_FROM,
3029: mtl_transaction_types MTT

Line 3175: FROM cst_item_list_temp CILT,

3171: (MS.rcv_transaction_id)),
3172: -- MTL_SUPPLY stores parent Match/Receive except for Accept/Reject/Transfers
3173: DECODE(p_qty_by_revision, 1, POL.item_revision, NULL),
3174: SUM(MS.to_org_primary_quantity) -- sum across po distributions
3175: FROM cst_item_list_temp CILT,
3176: cst_cg_list_temp CCLT,
3177: mtl_supply MS,
3178: rcv_transactions RT,
3179: mtl_parameters MP,

Line 3275: FROM cst_item_list_temp CILT,

3271: 'MATCH', -1 * RT.primary_quantity,
3272: 0),
3273: 0)
3274: ) rollback_qty
3275: FROM cst_item_list_temp CILT,
3276: cst_cg_list_temp CCLT,
3277: rcv_transactions RT,
3278: rcv_transactions PARENT_RT,
3279: rcv_transactions GRPARENT_RT,