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 165: INSERT INTO cst_item_list_temp(

161: p_cost_type_id IS NULL AND
162: l_def_cost_type_id = l_primary_cost_method
163: THEN
164:
165: INSERT INTO cst_item_list_temp(
166: inventory_item_id,
167: category_id,
168: cost_type_id
169: )

Line 206: INSERT INTO cst_item_list_temp(

202: );
203: ELSE
204: --}
205:
206: INSERT INTO cst_item_list_temp(
207: inventory_item_id,
208: category_id,
209: cost_type_id
210: )

Line 252: INTO cst_item_list_temp(

248: l_def_cost_type_id = l_primary_cost_method
249: THEN
250:
251: INSERT
252: INTO cst_item_list_temp(
253: inventory_item_id,
254: category_id,
255: cost_type_id
256: )

Line 303: INTO cst_item_list_temp(

299:
300: ELSE
301:
302: INSERT
303: INTO cst_item_list_temp(
304: inventory_item_id,
305: category_id,
306: cost_type_id
307: )

Line 366: INTO cst_item_list_temp(

362: -- because non-costing-enabled items are not excluded from the report.
363: -- The p_zero_cost_only and p_expense_item parameters are also ignored.
364: l_stmt_num := 30;
365: INSERT
366: INTO cst_item_list_temp(
367: inventory_item_id,
368: category_id,
369: cost_type_id
370: )

Line 403: INTO cst_item_list_temp(

399: END IF;
400:
401: IF p_one_time_item = 1 THEN
402: INSERT
403: INTO cst_item_list_temp(
404: inventory_item_id,
405: category_id,
406: cost_type_id
407: )

Line 808: cst_item_list_temp CILT,

804: DECODE(p_qty_by_revision,1,moq.revision,NULL),
805: CILT.category_id,
806: CILT.cost_type_id
807: FROM mtl_onhand_quantities MOQ,
808: cst_item_list_temp CILT,
809: cst_cg_list_temp CCLT,
810: cst_sub_list_temp CSLT
811: WHERE MOQ.organization_id = p_organization_id
812: AND CILT.inventory_item_id = MOQ.inventory_item_id

Line 864: cst_item_list_temp CILT,

860: MMT.transaction_source_type_id,
861: CILT.category_id,
862: CILT.cost_type_id
863: FROM mtl_material_transactions MMT,
864: cst_item_list_temp CILT,
865: cst_cg_list_temp CCLT,
866: cst_sub_list_temp CSLT
867: WHERE MMT.organization_id = p_organization_id
868: AND CILT.inventory_item_id = MMT.inventory_item_id

Line 949: cst_item_list_temp CILT

945: MMT.transaction_source_type_id,
946: CILT.category_id,
947: CILT.cost_type_id
948: FROM mtl_material_transactions MMT,
949: cst_item_list_temp CILT
950: WHERE MMT.organization_id = p_organization_id
951: AND CILT.inventory_item_id = MMT.inventory_item_id
952: AND MMT.costed_flag IS NULL
953: AND MMT.creation_date <= NVL(CST_Inventory_PVT.g_run_onhand_date,MMT.creation_date)

Line 1034: FROM cst_item_list_temp

1030: FROM (
1031: SELECT inventory_item_id,
1032: category_id,
1033: cost_type_id
1034: FROM cst_item_list_temp
1035: MINUS
1036: SELECT DISTINCT
1037: inventory_item_id,
1038: category_id,

Line 1226: cst_item_list_temp ITEMS,

1222: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
1223: ),
1224: MS.shipment_line_id
1225: FROM mtl_supply MS,
1226: cst_item_list_temp ITEMS,
1227: cst_cg_list_temp CGS,
1228: mtl_parameters MP,
1229: mtl_interorg_parameters MIP,
1230: mtl_material_transactions MMT,

Line 1331: cst_item_list_temp ITEMS,

1327: ),
1328: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1329: RSL.shipment_line_id
1330: FROM mtl_material_transactions MMT,
1331: cst_item_list_temp ITEMS,
1332: cst_cg_list_temp CGS,
1333: mtl_interorg_parameters MIP,
1334: mtl_system_items MSI_TO,
1335: rcv_shipment_headers RSH,

Line 1424: cst_item_list_temp ITEMS,

1420: ),
1421: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1422: RT.shipment_line_id
1423: FROM mtl_material_transactions MMT,
1424: cst_item_list_temp ITEMS,
1425: cst_cg_list_temp CGS,
1426: mtl_interorg_parameters MIP,
1427: mtl_system_items MSI_FROM,
1428: rcv_transactions RT

Line 1522: cst_item_list_temp ITEMS,

1518: ),
1519: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1520: RSL.shipment_line_id
1521: FROM mtl_material_transactions MMT,
1522: cst_item_list_temp ITEMS,
1523: cst_cg_list_temp CGS,
1524: mtl_interorg_parameters MIP,
1525: mtl_system_items MSI_TO,
1526: rcv_shipment_headers RSH,

Line 1632: cst_item_list_temp ITEMS,

1628: ),
1629: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1630: RT.shipment_line_id
1631: FROM mtl_material_transactions MMT,
1632: cst_item_list_temp ITEMS,
1633: cst_cg_list_temp CGS,
1634: mtl_interorg_parameters MIP,
1635: mtl_system_items MSI_FROM,
1636: rcv_transactions RT

Line 1730: cst_item_list_temp ITEMS,

1726: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
1727: ),
1728: MS.shipment_line_id
1729: FROM mtl_supply MS,
1730: cst_item_list_temp ITEMS,
1731: cst_cg_list_temp CGS,
1732: mtl_parameters MP,
1733: mtl_interorg_parameters MIP,
1734: mtl_material_transactions MMT,

Line 1837: cst_item_list_temp ITEMS,

1833: ),
1834: NVL(MMT.intransit_account,MIP.intransit_inv_account),
1835: RSL.shipment_line_id
1836: FROM mtl_material_transactions MMT,
1837: cst_item_list_temp ITEMS,
1838: cst_cg_list_temp CGS,
1839: mtl_interorg_parameters MIP,
1840: mtl_system_items MSI_TO,
1841: rcv_shipment_headers RSH,

Line 1935: cst_item_list_temp ITEMS,

1931: ),
1932: NVL(MMT.intransit_account, MIP.intransit_inv_account),
1933: RT.shipment_line_id
1934: FROM mtl_material_transactions MMT,
1935: cst_item_list_temp ITEMS,
1936: cst_cg_list_temp CGS,
1937: mtl_interorg_parameters MIP,
1938: mtl_system_items MSI_FROM,
1939: rcv_transactions RT

Line 2033: cst_item_list_temp ITEMS,

2029: ),
2030: NVL(MMT.intransit_account,MIP.intransit_inv_account),
2031: RSL.shipment_line_id
2032: FROM mtl_material_transactions MMT,
2033: cst_item_list_temp ITEMS,
2034: cst_cg_list_temp CGS,
2035: mtl_interorg_parameters MIP,
2036: mtl_system_items MSI_TO,
2037: rcv_shipment_headers RSH,

Line 2131: cst_item_list_temp ITEMS,

2127: ),
2128: NVL(MMT.intransit_account, MIP.intransit_inv_account),
2129: RT.shipment_line_id
2130: FROM mtl_material_transactions MMT,
2131: cst_item_list_temp ITEMS,
2132: cst_cg_list_temp CGS,
2133: mtl_interorg_parameters MIP,
2134: mtl_system_items MSI_FROM,
2135: rcv_transactions RT

Line 2247: cst_item_list_temp ITEMS,

2243: MMT.intransit_account,
2244: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
2245: )
2246: FROM mtl_supply MS,
2247: cst_item_list_temp ITEMS,
2248: cst_cg_list_temp CGS,
2249: mtl_parameters MP,
2250: mtl_interorg_parameters MIP,
2251: mtl_material_transactions MMT,

Line 2347: cst_item_list_temp ITEMS,

2343: )
2344: ),
2345: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2346: FROM mtl_material_transactions MMT,
2347: cst_item_list_temp ITEMS,
2348: cst_cg_list_temp CGS,
2349: mtl_interorg_parameters MIP,
2350: mtl_system_items MSI_TO
2351: WHERE Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id) = p_organization_id

Line 2432: cst_item_list_temp ITEMS,

2428: )
2429: ),
2430: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2431: FROM mtl_material_transactions MMT,
2432: cst_item_list_temp ITEMS,
2433: cst_cg_list_temp CGS,
2434: mtl_interorg_parameters MIP,
2435: mtl_system_items MSI_FROM
2436: WHERE MMT.organization_id = p_organization_id

Line 2525: cst_item_list_temp ITEMS,

2521: )
2522: ),
2523: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2524: FROM mtl_material_transactions MMT,
2525: cst_item_list_temp ITEMS,
2526: cst_cg_list_temp CGS,
2527: mtl_interorg_parameters MIP,
2528: mtl_system_items MSI_TO,
2529: mtl_transaction_types MTT

Line 2631: cst_item_list_temp ITEMS,

2627: )
2628: ),
2629: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2630: FROM mtl_material_transactions MMT,
2631: cst_item_list_temp ITEMS,
2632: cst_cg_list_temp CGS,
2633: mtl_interorg_parameters MIP,
2634: mtl_system_items MSI_FROM,
2635: mtl_transaction_types MTT

Line 2728: cst_item_list_temp ITEMS,

2724: MMT.intransit_account,
2725: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
2726: )
2727: FROM mtl_supply MS,
2728: cst_item_list_temp ITEMS,
2729: cst_cg_list_temp CGS,
2730: mtl_parameters MP,
2731: mtl_interorg_parameters MIP,
2732: mtl_material_transactions MMT,

Line 2830: cst_item_list_temp ITEMS,

2826: )
2827: ),
2828: NVL(MMT.intransit_account,MIP.intransit_inv_account)
2829: FROM mtl_material_transactions MMT,
2830: cst_item_list_temp ITEMS,
2831: cst_cg_list_temp CGS,
2832: mtl_interorg_parameters MIP,
2833: mtl_system_items MSI_TO
2834: WHERE MMT.organization_id = p_organization_id

Line 2920: cst_item_list_temp ITEMS,

2916: )
2917: ),
2918: NVL(MMT.intransit_account, MIP.intransit_inv_account)
2919: FROM mtl_material_transactions MMT,
2920: cst_item_list_temp ITEMS,
2921: cst_cg_list_temp CGS,
2922: mtl_interorg_parameters MIP,
2923: mtl_system_items MSI_FROM
2924: WHERE Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id) = p_organization_id

Line 3014: cst_item_list_temp ITEMS,

3010: )
3011: ),
3012: NVL(MMT.intransit_account,MIP.intransit_inv_account)
3013: FROM mtl_material_transactions MMT,
3014: cst_item_list_temp ITEMS,
3015: cst_cg_list_temp CGS,
3016: mtl_interorg_parameters MIP,
3017: mtl_system_items MSI_TO,
3018: mtl_transaction_types MTT

Line 3108: cst_item_list_temp ITEMS,

3104: )
3105: ),
3106: NVL(MMT.intransit_account, MIP.intransit_inv_account)
3107: FROM mtl_material_transactions MMT,
3108: cst_item_list_temp ITEMS,
3109: cst_cg_list_temp CGS,
3110: mtl_interorg_parameters MIP,
3111: mtl_system_items MSI_FROM,
3112: mtl_transaction_types MTT

Line 3270: FROM cst_item_list_temp CILT,

3266: (MS.rcv_transaction_id)),
3267: -- MTL_SUPPLY stores parent Match/Receive except for Accept/Reject/Transfers
3268: DECODE(p_qty_by_revision, 1, POL.item_revision, NULL),
3269: SUM(MS.to_org_primary_quantity) -- sum across po distributions
3270: FROM cst_item_list_temp CILT,
3271: cst_cg_list_temp CCLT,
3272: mtl_supply MS,
3273: rcv_transactions RT,
3274: mtl_parameters MP,

Line 3371: FROM cst_item_list_temp CILT,

3367: 'MATCH', -1 * RT.primary_quantity,
3368: 0),
3369: 0)
3370: ) rollback_qty
3371: FROM cst_item_list_temp CILT,
3372: cst_cg_list_temp CCLT,
3373: rcv_transactions RT,
3374: rcv_transactions PARENT_RT,
3375: rcv_transactions GRPARENT_RT,