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_CG_LIST_TEMP

Line 461: INTO cst_cg_list_temp(

457:
458: -- Populate cost group list for the current organization
459: l_stmt_num := 10;
460: INSERT
461: INTO cst_cg_list_temp(
462: cost_group_id
463: )
464: SELECT CCG.cost_group_id
465: FROM cst_cost_groups CCG,

Line 484: FROM cst_cg_list_temp CGLT

480: AND CCG.cost_group
481: BETWEEN NVL(p_cost_group_from, CCG.cost_group)
482: AND NVL(p_cost_group_to, CCG.cost_group)
483: AND NOT EXISTS( SELECT 'Cost Group already exists'
484: FROM cst_cg_list_temp CGLT
485: where CGLT.cost_group_id = CCG.cost_group_id
486: );
487:
488:

Line 505: INTO cst_cg_list_temp(

501: IF NVL(p_own, -1) <> 1
502: THEN
503: l_stmt_num := 20;
504: INSERT
505: INTO cst_cg_list_temp(
506: cost_group_id
507: )
508: (SELECT DISTINCT
509: CCG.cost_group_id

Line 536: FROM cst_cg_list_temp);

532: AND MIP.from_organization_id = CCGA.organization_id)
533: )
534: MINUS
535: SELECT cost_group_id
536: FROM cst_cg_list_temp);
537:
538: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg(

Line 740: cst_cg_list_temp CCLT,

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
744: AND CCLT.cost_group_id = MOQ.cost_group_id

Line 795: cst_cg_list_temp CCLT,

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
799: AND CCLT.cost_group_id = MMT.cost_group_id

Line 900: FROM cst_cg_list_temp CCLT

896: AND MMT.cost_group_id IS NULL
897: )
898: OR EXISTS (
899: SELECT 1
900: FROM cst_cg_list_temp CCLT
901: WHERE CCLT.cost_group_id = MMT.cost_group_id)
902: )
903: -- The only transactions other than the ones ignored above that
904: -- affect inventory valuation and have null subinventory_code are

Line 1151: cst_cg_list_temp CGS,

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,
1155: rcv_shipment_lines RSL,

Line 1254: cst_cg_list_temp CGS,

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,
1258: rcv_shipment_lines RSL

Line 1350: cst_cg_list_temp CGS,

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
1354: WHERE MMT.organization_id = p_organization_id

Line 1451: cst_cg_list_temp CGS,

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,
1455: rcv_shipment_lines RSL

Line 1552: cst_cg_list_temp CGS,

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
1556: WHERE MMT.organization_id = p_organization_id

Line 1651: cst_cg_list_temp CGS,

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,
1655: rcv_shipment_lines RSL,

Line 1757: cst_cg_list_temp CGS,

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,
1761: rcv_shipment_lines RSL

Line 1857: cst_cg_list_temp CGS,

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
1861: WHERE MMT.transfer_organization_id = p_organization_id

Line 1958: cst_cg_list_temp CGS,

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,
1962: rcv_shipment_lines RSL

Line 2059: cst_cg_list_temp CGS,

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
2063: WHERE MMT.transfer_organization_id = p_organization_id

Line 2163: cst_cg_list_temp CGS,

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,
2167: rcv_shipment_lines RSL,

Line 2261: cst_cg_list_temp CGS,

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
2265: AND MMT.transaction_action_id = 21

Line 2349: cst_cg_list_temp CGS,

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
2353: AND MMT.transaction_action_id = 12

Line 2445: cst_cg_list_temp CGS,

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
2449: WHERE MMT.transfer_organization_id = p_organization_id

Line 2542: cst_cg_list_temp CGS,

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
2546: WHERE MMT.organization_id = p_organization_id

Line 2640: cst_cg_list_temp CGS,

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,
2644: rcv_shipment_lines RSL,

Line 2741: cst_cg_list_temp CGS,

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
2745: AND MMT.transaction_action_id = 21

Line 2833: cst_cg_list_temp CGS,

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
2837: AND MMT.transaction_action_id = 12

Line 2929: cst_cg_list_temp CGS,

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
2933: WHERE MMT.organization_id = p_organization_id

Line 3026: cst_cg_list_temp CGS,

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
3030: WHERE MMT.transfer_organization_id = p_organization_id

Line 3176: cst_cg_list_temp CCLT,

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,
3180: po_lines_all POL,

Line 3276: cst_cg_list_temp CCLT,

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,
3280: mtl_parameters MP,