APPS.PO_ASL_API_PVT dependencies on PO_ASL_ATTRIBUTES_GT

Line 263: FROM po_asl_attributes_gt

259: vmi_min_days_dsp ,
260: vmi_max_days_dsp ,
261: fixed_order_quantity_dsp ,
262: forecast_horizon_dsp
263: FROM po_asl_attributes_gt
264: WHERE user_key IN
265: (SELECT user_key
266: FROM po_approved_supplier_list_gt
267: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED) AND

Line 411: FROM po_asl_attributes_gt PAA

407: PASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
408: (Upper(PASL.vendor_business_type) = 'MANUFACTURER' OR
409: NOT EXISTS
410: (SELECT PAA.user_key
411: FROM po_asl_attributes_gt PAA
412: WHERE PAA.user_key = PASL.user_key))
413: );
414: po_asl_api_pvt.log('number of DEFAULT rows inserted into po_asl_attributes:'
415: || SQL%ROWCOUNT);

Line 907: FROM po_asl_attributes_gt PAAGT ,

903: PAAGT.vmi_min_days_dsp ,
904: PAAGT.vmi_max_days_dsp ,
905: PAAGT.fixed_order_quantity_dsp ,
906: PAAGT.forecast_horizon_dsp
907: FROM po_asl_attributes_gt PAAGT ,
908: po_approved_supplier_list_gt ASLGT
909: WHERE PAAGT.user_key = ASLGT.user_key
910: AND PAAGT.asl_id = PAA.asl_id
911: AND PAAGT.using_organization_id = PAA.using_organization_id

Line 917: FROM po_asl_attributes_gt PAAGT,

913: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
914: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
915: WHERE (PAA.asl_id, PAA.using_organization_id) IN
916: (SELECT PAAGT.asl_id, PAAGT.using_organization_id
917: FROM po_asl_attributes_gt PAAGT,
918: po_approved_supplier_list_gt ASLGT
919: WHERE ASLGT.user_key = PAAGT.user_key
920: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
921: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

Line 1252: FROM po_asl_attributes_gt PAAGT,

1248: DELETE FROM po_asl_attributes PAA
1249: WHERE (asl_id, using_organization_id) IN
1250: (SELECT PAAGT.asl_id,
1251: PAAGT.using_organization_id
1252: FROM po_asl_attributes_gt PAAGT,
1253: po_approved_supplier_list_gt ASLGT
1254: WHERE ASLGT.user_key = PAAGT.user_key
1255: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1256: AND PAAGT.asl_id = PAA.asl_id