DBA Data[Home] [Help]

APPS.INV_PO_ITEMVALID_MDTR dependencies on PO_ASL_STATUS_RULES

Line 120: po_asl_status_rules pasr

116: SELECT 'Y'
117: INTO l_vmiorconsign_flag
118: FROM po_approved_supplier_list pasl,
119: po_asl_attributes paa,
120: po_asl_status_rules pasr
121: WHERE pasl.item_id = p_item_id
122: AND pasl.using_organization_id IN (-1,p_organization_id)
123: AND pasl.asl_id = paa.asl_id
124: AND pasr.business_rule = '2_SOURCING'

Line 253: po_asl_status_rules pasr

249: SELECT 'Y'
250: INTO l_consign_flag
251: FROM po_approved_supplier_list pasl,
252: po_asl_attributes paa,
253: po_asl_status_rules pasr
254: WHERE pasl.item_id = p_item_id
255: AND pasl.using_organization_id IN (-1,p_organization_id)
256: AND pasl.asl_id = paa.asl_id
257: AND pasr.business_rule = '2_SOURCING'