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.

[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on CST_CG_LIST_TEMP

Line 499: INTO cst_cg_list_temp(

495:
496: -- Populate cost group list for the current organization
497: l_stmt_num := 10;
498: INSERT
499: INTO cst_cg_list_temp(
500: cost_group_id
501: )
502: SELECT CCG.cost_group_id
503: FROM cst_cost_groups CCG,

Line 533: FROM cst_cg_list_temp CGLT

529: AND CCG.cost_group
530: BETWEEN NVL(p_cost_group_from, CCG.cost_group)
531: AND NVL(p_cost_group_to, CCG.cost_group)
532: AND NOT EXISTS( SELECT 'Cost Group already exists'
533: FROM cst_cg_list_temp CGLT
534: where CGLT.cost_group_id = CCG.cost_group_id
535: );
536:
537:

Line 554: INTO cst_cg_list_temp(

550: IF NVL(p_own, -1) <> 1
551: THEN
552: l_stmt_num := 20;
553: INSERT
554: INTO cst_cg_list_temp(
555: cost_group_id
556: )
557: (SELECT DISTINCT
558: CCG.cost_group_id

Line 596: FROM cst_cg_list_temp);

592: AND MIP.from_organization_id = CCGA.organization_id)
593: )
594: MINUS
595: SELECT cost_group_id
596: FROM cst_cg_list_temp);
597:
598: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
599: THEN
600: FND_MSG_PUB.Add_Exc_Msg(

Line 809: cst_cg_list_temp CCLT,

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

Line 865: cst_cg_list_temp CCLT,

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

Line 975: FROM cst_cg_list_temp CCLT

971: AND MMT.cost_group_id IS NULL
972: )
973: OR EXISTS (
974: SELECT 1
975: FROM cst_cg_list_temp CCLT
976: WHERE CCLT.cost_group_id = MMT.cost_group_id)
977: )
978: -- The only transactions other than the ones ignored above that
979: -- affect inventory valuation and have null subinventory_code are

Line 1227: cst_cg_list_temp CGS,

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

Line 1332: cst_cg_list_temp CGS,

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

Line 1425: cst_cg_list_temp CGS,

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

Line 1523: cst_cg_list_temp CGS,

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

Line 1633: cst_cg_list_temp CGS,

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

Line 1731: cst_cg_list_temp CGS,

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

Line 1838: cst_cg_list_temp CGS,

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

Line 1936: cst_cg_list_temp CGS,

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
1940: WHERE Decode(MMT.transaction_action_id, 12, MMT.transfer_organization_id, 22, MMT.organization_id) = p_organization_id

Line 2034: cst_cg_list_temp CGS,

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

Line 2132: cst_cg_list_temp CGS,

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

Line 2248: cst_cg_list_temp CGS,

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

Line 2348: cst_cg_list_temp CGS,

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
2352: AND MMT.transaction_action_id IN (21, 15)

Line 2433: cst_cg_list_temp CGS,

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

Line 2526: cst_cg_list_temp CGS,

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

Line 2632: cst_cg_list_temp CGS,

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

Line 2729: cst_cg_list_temp CGS,

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

Line 2831: cst_cg_list_temp CGS,

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

Line 2921: cst_cg_list_temp CGS,

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
2925: AND MMT.transaction_action_id IN (12,22)

Line 3015: cst_cg_list_temp CGS,

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

Line 3109: cst_cg_list_temp CGS,

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

Line 3271: cst_cg_list_temp CCLT,

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

Line 3372: cst_cg_list_temp CCLT,

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