APPS.INV_PO_ITEMVALID_MDTR dependencies on PO_ASL_ATTRIBUTES

Line 119: po_asl_attributes paa,

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)
123: AND pasl.asl_id = paa.asl_id

Line 129: FROM po_asl_attributes paa2

125: AND pasr.allow_action_flag = 'Y'
126: AND pasr.status_id = pasl.asl_status_id
127: AND (disable_flag IS NULL OR disable_flag = 'N')
128: AND paa.using_organization_id = (SELECT max(paa2.using_organization_id)
129: FROM po_asl_attributes paa2
130: WHERE paa2.asl_id = pasl.asl_id
131: AND paa2.using_organization_id IN (-1,p_organization_id))
132: AND (paa.consigned_from_supplier_flag='Y' OR paa.enable_vmi_flag='Y')
133: AND rownum=1;

Line 252: po_asl_attributes paa,

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)
256: AND pasl.asl_id = paa.asl_id

Line 262: FROM po_asl_attributes paa2

258: AND pasr.allow_action_flag = 'Y'
259: AND pasr.status_id = pasl.asl_status_id
260: AND (disable_flag IS NULL OR disable_flag = 'N')
261: AND paa.using_organization_id = (SELECT max(paa2.using_organization_id)
262: FROM po_asl_attributes paa2
263: WHERE paa2.asl_id = pasl.asl_id
264: AND paa2.using_organization_id IN (-1,p_organization_id))
265: AND paa.consigned_from_supplier_flag='Y'
266: AND rownum=1;