114: -- End API initialization
115:
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)
247: ELSE
248:
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)