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 MTL_INTERORG_PARAMETERS

Line 582: mtl_interorg_parameters MIP

578: SELECT p_organization_id,
579: 1
580: FROM dual
581: ) CCGA,
582: mtl_interorg_parameters MIP
583: WHERE CCG.cost_group_id = CCGA.cost_group_id
584: AND NVL(CCG.disable_date, sysdate+1) > sysdate
585: AND CCG.cost_group
586: BETWEEN NVL(p_cost_group_from, CCG.cost_group)

Line 1229: mtl_interorg_parameters MIP,

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,
1232: mtl_system_items MSI_FROM
1233: WHERE MS.to_organization_id = p_organization_id

Line 1333: mtl_interorg_parameters MIP,

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
1337: WHERE Decode(MMT.transaction_action_id, 21, MMT.transfer_organization_id, 15, MMT.organization_id) = p_organization_id

Line 1426: mtl_interorg_parameters MIP,

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

Line 1524: mtl_interorg_parameters MIP,

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

Line 1634: mtl_interorg_parameters MIP,

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

Line 1733: mtl_interorg_parameters MIP,

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,
1736: mtl_system_items MSI_FROM
1737: WHERE MS.from_organization_id = p_organization_id

Line 1839: mtl_interorg_parameters MIP,

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

Line 1937: mtl_interorg_parameters MIP,

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

Line 2035: mtl_interorg_parameters MIP,

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

Line 2133: mtl_interorg_parameters MIP,

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

Line 2250: mtl_interorg_parameters MIP,

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,
2253: mtl_system_items MSI_FROM
2254: WHERE MS.to_organization_id = p_organization_id

Line 2349: mtl_interorg_parameters MIP,

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)
2353: AND MMT.costed_flag IN ('N','E')

Line 2434: mtl_interorg_parameters MIP,

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
2438: AND MMT.costed_flag IN ('N', 'E')

Line 2527: mtl_interorg_parameters MIP,

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

Line 2633: mtl_interorg_parameters MIP,

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

Line 2731: mtl_interorg_parameters MIP,

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,
2734: mtl_system_items MSI_FROM
2735: WHERE MS.from_organization_id = p_organization_id

Line 2832: mtl_interorg_parameters MIP,

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
2836: AND MMT.costed_flag IN ('N','E')

Line 2922: mtl_interorg_parameters MIP,

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)
2926: AND MMT.costed_flag IN ('N', 'E')

Line 3016: mtl_interorg_parameters MIP,

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

Line 3110: mtl_interorg_parameters MIP,

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

Line 4468: from mtl_interorg_parameters

4464: from_organization_id) relevant_org,
4465: fob_point,
4466: from_organization_id,
4467: to_organization_id
4468: from mtl_interorg_parameters
4469: where from_organization_id = p_organization_id
4470: or to_organization_id = p_organization_id) MIP,
4471: MTL_MATERIAL_TRANSACTIONS MMT,
4472: MTL_CST_ACTUAL_COST_DETAILS MCACD