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 477: po_approved_supplier_list split one query into two as below

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

Line 491: FROM po_approved_supplier_list pasl

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

Line 499: FROM po_approved_supplier_list pasl

495: else
496:
497: SELECT count(1)
498: INTO x_dummy_count
499: FROM po_approved_supplier_list pasl
500: WHERE pasl.manufacturer_id = x_manufacturer_id
501: AND pasl.using_organization_id = x_using_organization_id
502: AND pasl.category_id = x_category_id;
503:

Line 509: po_approved_supplier_list split one query into two as below

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

Line 516: FROM po_approved_supplier_list pasl

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

Line 526: FROM po_approved_supplier_list pasl

522: else
523:
524: SELECT count(1)
525: INTO x_dummy_count
526: FROM po_approved_supplier_list pasl
527: WHERE pasl.vendor_id = x_vendor_id
528: AND ((pasl.vendor_site_id is null AND x_vendor_site_id is null) OR
529: (pasl.vendor_site_id = x_vendor_site_id))
530: AND pasl.using_organization_id = x_using_organization_id

Line 541: FROM po_approved_supplier_list pasl,po_asl_attributes paa

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

Line 874: l_using_org_id PO_APPROVED_SUPPLIER_LIST.using_organization_id%TYPE;

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

Line 876: l_item_id PO_APPROVED_SUPPLIER_LIST.item_id%TYPE;

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

Line 909: FROM po_approved_supplier_list PASL,

905: l_vendor_name,
906: l_vendor_site_code,
907: l_category_name,
908: l_item_name
909: FROM po_approved_supplier_list PASL,
910: mtl_parameters MP,
911: mtl_manufacturers MM,
912: po_vendors PV,
913: po_vendor_sites_all PVS,