eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ASL_SV dependencies on PO_APPROVED_SUPPLIER_LIST

Line 73: -- Query from po_approved_supplier_list to get the status (asl_status_id)

69: begin
70:
71: --dbms_output.put_line('Entering check_asl_action');
72:
73: -- Query from po_approved_supplier_list to get the status (asl_status_id)
74: -- of the supplier, site, item, organization, category.
75: x_progress := '010';
76:
77: -- Based on the status_id query from po_asl_status_rules to see

Line 106: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with

102:
103: /*1517028 Breaking sql statement into three diffrent sql statements to
104: remove OR between checks for item_id and category id...never combine them...*/
105:
106: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with
107: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with
108: PO_ASL_STATUS_RULES_V
109: */
110:

Line 120: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with

116: AND ASL.item_id = x_item_id
117: AND ASL.asl_status_id = ASR.status_id
118: AND ASR.business_rule = x_action;
119:
120: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with
121: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with
122: PO_ASL_STATUS_RULES_V
123: */
124: IF x_asl_status IS NULL THEN

Line 135: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with

131: AND ASL.asl_status_id = ASR.status_id
132: AND ASR.business_rule = x_action;
133: END IF;
134:
135: /* Bug: 1968168 Replace PO_APPROVED_SUPPLIER_LIST with
136: PO_APPROVED_SUPPLIER_LIS_VAL_V and PO_ASL_STATUS_RULES ASR with
137: PO_ASL_STATUS_RULES_V
138: */
139:

Line 244: update po_approved_supplier_list pasl

240:
241: if NVL(x_global_asl_update,'N') = 'N' then
242: l_progress := '010';
243:
244: update po_approved_supplier_list pasl
245: set pasl.asl_status_id = x_status_id
246: where pasl.using_organization_id = x_organization_id
247: and pasl.vendor_id = x_vendor_id
248: and pasl.vendor_site_id = NVL(x_vendor_site_id,pasl.vendor_site_id)

Line 259: update po_approved_supplier_list pasl

255: BULK COLLECT INTO l_asl_id_tbl; --
256: else
257: l_progress := '020';
258:
259: update po_approved_supplier_list pasl
260: set pasl.asl_status_id = x_status_id
261: where pasl.using_organization_id in (x_organization_id,-1)
262: and pasl.vendor_id = x_vendor_id
263: and pasl.vendor_site_id = NVL(x_vendor_site_id,pasl.vendor_site_id)

Line 473: po_approved_supplier_list split one query into two as below

469: if (x_manufacturer_id is not null) then
470:
471: /*Bug 1261392
472: A performance issue and to use the index on item id in
473: po_approved_supplier_list split one query into two as below
474: based on the value of x_item_id.
475: */
476:
477: -- bug3648471

Line 487: FROM po_approved_supplier_list pasl

483: if (x_item_id is not null) then
484:
485: SELECT count(1)
486: INTO x_dummy_count
487: FROM po_approved_supplier_list pasl
488: WHERE pasl.manufacturer_id = x_manufacturer_id
489: AND pasl.using_organization_id = x_using_organization_id
490: AND pasl.item_id = x_item_id;
491: else

Line 495: FROM po_approved_supplier_list pasl

491: else
492:
493: SELECT count(1)
494: INTO x_dummy_count
495: FROM po_approved_supplier_list pasl
496: WHERE pasl.manufacturer_id = x_manufacturer_id
497: AND pasl.using_organization_id = x_using_organization_id
498: AND pasl.category_id = x_category_id;
499:

Line 505: po_approved_supplier_list split one query into two as below

501: else
502:
503: /*Bug 1261392
504: A performance issue and to use the index on item id in
505: po_approved_supplier_list split one query into two as below
506: based on the value of x_item_id.
507: */
508: if (x_item_id is not null) then
509:

Line 512: FROM po_approved_supplier_list pasl

508: if (x_item_id is not null) then
509:
510: SELECT count(1)
511: INTO x_dummy_count
512: FROM po_approved_supplier_list pasl
513: WHERE pasl.vendor_id = x_vendor_id
514: AND ((pasl.vendor_site_id is null AND x_vendor_site_id is null) OR
515: (pasl.vendor_site_id = x_vendor_site_id))
516: AND pasl.using_organization_id = x_using_organization_id

Line 522: FROM po_approved_supplier_list pasl

518: else
519:
520: SELECT count(1)
521: INTO x_dummy_count
522: FROM po_approved_supplier_list pasl
523: WHERE pasl.vendor_id = x_vendor_id
524: AND ((pasl.vendor_site_id is null AND x_vendor_site_id is null) OR
525: (pasl.vendor_site_id = x_vendor_site_id))
526: AND pasl.using_organization_id = x_using_organization_id

Line 537: FROM po_approved_supplier_list pasl,po_asl_attributes paa

533:
534: if (x_using_organization_id <> -1) then
535: SELECT count(1)
536: INTO x_dummy_count_local_attr
537: FROM po_approved_supplier_list pasl,po_asl_attributes paa
538: WHERE pasl.vendor_id = x_vendor_id
539: AND ((pasl.vendor_site_id is null AND x_vendor_site_id is null) OR
540: (pasl.vendor_site_id = x_vendor_site_id))
541: AND pasl.using_organization_id = -1

Line 870: l_using_org_id PO_APPROVED_SUPPLIER_LIST.using_organization_id%TYPE;

866: l_module CONSTANT FND_LOG_MESSAGES.module%TYPE :=
867: G_MODULE_PREFIX || l_api_name || '.';
868: l_progress VARCHAR2(3);
869:
870: l_using_org_id PO_APPROVED_SUPPLIER_LIST.using_organization_id%TYPE;
871: l_organization VARCHAR2(30);
872: l_item_id PO_APPROVED_SUPPLIER_LIST.item_id%TYPE;
873: l_vendor_name PO_VENDORS.vendor_name%TYPE;
874: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

Line 872: l_item_id PO_APPROVED_SUPPLIER_LIST.item_id%TYPE;

868: l_progress VARCHAR2(3);
869:
870: l_using_org_id PO_APPROVED_SUPPLIER_LIST.using_organization_id%TYPE;
871: l_organization VARCHAR2(30);
872: l_item_id PO_APPROVED_SUPPLIER_LIST.item_id%TYPE;
873: l_vendor_name PO_VENDORS.vendor_name%TYPE;
874: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
875: l_category_name MTL_CATEGORIES_KFV.concatenated_segments%TYPE;
876: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

Line 905: FROM po_approved_supplier_list PASL,

901: l_vendor_name,
902: l_vendor_site_code,
903: l_category_name,
904: l_item_name
905: FROM po_approved_supplier_list PASL,
906: mtl_parameters MP,
907: mtl_manufacturers MM,
908: po_vendors PV,
909: po_vendor_sites_all PVS,