DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on MTL_SYSTEM_ITEMS

Line 891: FROM MTL_SYSTEM_ITEMS

887: x_progress := '001';
888: BEGIN
889: SELECT distinct 'Y'
890: INTO x_valid_flag
891: FROM MTL_SYSTEM_ITEMS
892: WHERE inventory_item_id = x_item_id
893: AND purchasing_enabled_flag = 'Y'
894: AND organization_id = x_inv_org_id;
895: EXCEPTION

Line 923: FROM MTL_SYSTEM_ITEMS MSI

919: x_progress := '002';
920: BEGIN
921: SELECT distinct 'Y'
922: INTO x_valid_flag
923: FROM MTL_SYSTEM_ITEMS MSI
924: WHERE MSI.inventory_item_id = x_item_id
925: AND MSI.organization_id = x_inv_org_id
926: AND (MSI.outside_operation_flag <> 'Y'
927: OR (MSI.outside_operation_flag = 'Y'

Line 1988: from mtl_system_items msi

1984: and (x_item_id is null
1985: or
1986: (x_item_id is not null
1987: and exists (select null
1988: from mtl_system_items msi
1989: where msi.organization_id = nvl(x_ship_to_organization_id, msi.organization_id)
1990: and msi.inventory_item_id = x_item_id
1991: and (msi.restrict_subinventories_code = 2
1992: or (msi.restrict_subinventories_code = 1