APPS.CST_INVENTORY_PVT dependencies on RCV_SHIPMENT_LINES

Line 1231: rcv_shipment_lines RSL,

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
1234: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
1235: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)

Line 1336: rcv_shipment_lines RSL

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
1338: AND MMT.transaction_action_id IN (21, 15)
1339: AND MMT.costed_flag IN ('N','E')
1340: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 1527: rcv_shipment_lines RSL

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
1529: AND MMT.transaction_action_id = 21
1530: AND MMT.costed_flag IS NULL
1531: /* Bug 9764385: Modified the query to include Logical Intransit transactions */

Line 1735: rcv_shipment_lines RSL,

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
1738: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
1739: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)

Line 1842: rcv_shipment_lines RSL

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
1844: AND MMT.transaction_action_id = 21
1845: AND MMT.costed_flag IN ('N','E')
1846: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 2038: rcv_shipment_lines RSL

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
2040: AND MMT.transaction_action_id = 21
2041: AND MMT.costed_flag IS NULL
2042: AND MMT.transaction_date > p_valuation_date

Line 2252: rcv_shipment_lines RSL,

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
2255: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
2256: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)

Line 2733: rcv_shipment_lines RSL,

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
2736: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
2737: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)