DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on RCV_SHIPMENT_LINES

Line 1155: rcv_shipment_lines RSL,

1151: cst_cg_list_temp CGS,
1152: mtl_parameters MP,
1153: mtl_interorg_parameters MIP,
1154: mtl_material_transactions MMT,
1155: rcv_shipment_lines RSL,
1156: mtl_system_items MSI_FROM
1157: WHERE MS.to_organization_id = p_organization_id
1158: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
1159: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)

Line 1258: rcv_shipment_lines RSL

1254: cst_cg_list_temp CGS,
1255: mtl_interorg_parameters MIP,
1256: mtl_system_items MSI_TO,
1257: rcv_shipment_headers RSH,
1258: rcv_shipment_lines RSL
1259: WHERE MMT.transfer_organization_id = p_organization_id
1260: AND MMT.transaction_action_id = 21
1261: AND MMT.costed_flag IN ('N','E')
1262: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 1455: rcv_shipment_lines RSL

1451: cst_cg_list_temp CGS,
1452: mtl_interorg_parameters MIP,
1453: mtl_system_items MSI_TO,
1454: rcv_shipment_headers RSH,
1455: rcv_shipment_lines RSL
1456: WHERE MMT.transfer_organization_id = p_organization_id
1457: AND MMT.transaction_action_id = 21
1458: AND MMT.costed_flag IS NULL
1459: AND MMT.transaction_date > p_valuation_date

Line 1655: rcv_shipment_lines RSL,

1651: cst_cg_list_temp CGS,
1652: mtl_parameters MP,
1653: mtl_interorg_parameters MIP,
1654: mtl_material_transactions MMT,
1655: rcv_shipment_lines RSL,
1656: mtl_system_items MSI_FROM
1657: WHERE MS.from_organization_id = p_organization_id
1658: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
1659: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)

Line 1761: rcv_shipment_lines RSL

1757: cst_cg_list_temp CGS,
1758: mtl_interorg_parameters MIP,
1759: mtl_system_items MSI_TO,
1760: rcv_shipment_headers RSH,
1761: rcv_shipment_lines RSL
1762: WHERE MMT.organization_id = p_organization_id
1763: AND MMT.transaction_action_id = 21
1764: AND MMT.costed_flag IN ('N','E')
1765: AND MMT.inventory_item_id = ITEMS.inventory_item_id

Line 1962: rcv_shipment_lines RSL

1958: cst_cg_list_temp CGS,
1959: mtl_interorg_parameters MIP,
1960: mtl_system_items MSI_TO,
1961: rcv_shipment_headers RSH,
1962: rcv_shipment_lines RSL
1963: WHERE MMT.organization_id = p_organization_id
1964: AND MMT.transaction_action_id = 21
1965: AND MMT.costed_flag IS NULL
1966: AND MMT.transaction_date > p_valuation_date

Line 2167: rcv_shipment_lines RSL,

2163: cst_cg_list_temp CGS,
2164: mtl_parameters MP,
2165: mtl_interorg_parameters MIP,
2166: mtl_material_transactions MMT,
2167: rcv_shipment_lines RSL,
2168: mtl_system_items MSI_FROM
2169: WHERE MS.to_organization_id = p_organization_id
2170: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
2171: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)

Line 2644: rcv_shipment_lines RSL,

2640: cst_cg_list_temp CGS,
2641: mtl_parameters MP,
2642: mtl_interorg_parameters MIP,
2643: mtl_material_transactions MMT,
2644: rcv_shipment_lines RSL,
2645: mtl_system_items MSI_FROM
2646: WHERE MS.from_organization_id = p_organization_id
2647: /* AND MS.intransit_owning_org_id = p_organization_id */ /* Bug 5664736 */
2648: AND MS.intransit_owning_org_id = DECODE(NVL(p_own,-1),1,p_organization_id,MS.intransit_owning_org_id)