APPS.CST_INVENTORY_PVT dependencies on MTL_SUPPLY

Line 1225: FROM mtl_supply MS,

1221: MMT.intransit_account,
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,

Line 1729: FROM mtl_supply MS,

1725: MMT.intransit_account,
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,

Line 2246: FROM mtl_supply MS,

2242: NVL(
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,

Line 2727: FROM mtl_supply MS,

2723: NVL(
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,

Line 3240: -- stored by the rcv_transaction_id stored in MTL_SUPPLY, which was

3236:
3237: -- Calculate current receiving quantity with qty_source = 9
3238: -- Release 12i: Modified to store quantities always by the parent
3239: -- RECEIVE or MATCH transaction. Prior to 12i, quantity was always
3240: -- stored by the rcv_transaction_id stored in MTL_SUPPLY, which was
3241: -- the parent RECEIVE or MATCH with the exception of cases in which
3242: -- there was an Accept/Reject/Transfer transaction.
3243: l_stmt_num := 10;
3244: /*Initialize g_run_receiving_date */

Line 3267: -- MTL_SUPPLY stores parent Match/Receive except for Accept/Reject/Transfers

3263: 'ACCEPT', Get_ParentReceiveTxn(MS.rcv_transaction_id),
3264: 'REJECT', Get_ParentReceiveTxn(MS.rcv_transaction_id),
3265: 'TRANSFER', Get_ParentReceiveTxn(MS.rcv_transaction_id),
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,

Line 3272: mtl_supply MS,

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,
3276: po_line_locations_all POLL,