APPS.CST_INVENTORY_PVT dependencies on MTL_SUPPLY

Line 1149: FROM mtl_supply MS,

1145: MMT.intransit_account,
1146: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
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,

Line 1649: FROM mtl_supply MS,

1645: MMT.intransit_account,
1646: NVL(MIP.intransit_inv_account,MP.intransit_inv_account)
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,

Line 2161: FROM mtl_supply MS,

2157: NVL(
2158: MMT.intransit_account,
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,

Line 2638: FROM mtl_supply MS,

2634: NVL(
2635: MMT.intransit_account,
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,

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

3143:
3144: -- Calculate current receiving quantity with qty_source = 9
3145: -- Release 12i: Modified to store quantities always by the parent
3146: -- RECEIVE or MATCH transaction. Prior to 12i, quantity was always
3147: -- stored by the rcv_transaction_id stored in MTL_SUPPLY, which was
3148: -- the parent RECEIVE or MATCH with the exception of cases in which
3149: -- there was an Accept/Reject/Transfer transaction.
3150: l_stmt_num := 10;
3151: INSERT

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

3168: 'ACCEPT', Get_ParentReceiveTxn(MS.rcv_transaction_id),
3169: 'REJECT', Get_ParentReceiveTxn(MS.rcv_transaction_id),
3170: 'TRANSFER', Get_ParentReceiveTxn(MS.rcv_transaction_id),
3171: (MS.rcv_transaction_id)),
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,

Line 3177: mtl_supply MS,

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