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_API_GRP dependencies on PO_APPROVED_SUPPLIER_LIST

Line 82: UPDATE po_approved_supplier_list_gt GT

78: po_asl_api_pvt.log('START ::: po_asl_api_grp.process');
79: po_asl_api_pvt.log('p_session_key:' || p_session_key);
80: g_session_key := p_session_key;
81: --Determine Create/Update when mode is Sync
82: UPDATE po_approved_supplier_list_gt GT
83: SET GT.process_action =
84: determine_action(
85: p_item_id => GT.item_id ,
86: p_category_id => GT.category_id ,

Line 97: UPDATE po_approved_supplier_list_gt GT

93: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
94:
95: --Populate asl ids in case of update
96: /* RR: Review Perf */
97: UPDATE po_approved_supplier_list_gt GT
98: SET asl_id =
99: (SELECT asl_id
100: FROM po_approved_supplier_list PASL
101: WHERE (GT.item_id = PASL.item_id

Line 100: FROM po_approved_supplier_list PASL

96: /* RR: Review Perf */
97: UPDATE po_approved_supplier_list_gt GT
98: SET asl_id =
99: (SELECT asl_id
100: FROM po_approved_supplier_list PASL
101: WHERE (GT.item_id = PASL.item_id
102: OR GT.category_id = PASL.category_id)
103: AND GT.using_organization_id = PASL.using_organization_id
104: AND (GT.vendor_id = PASL.vendor_id

Line 113: UPDATE po_approved_supplier_list_gt GT

109: l_progress := 10;
110: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
111:
112: --Populate asl ids in case of create
113: UPDATE po_approved_supplier_list_gt GT
114: SET asl_id = po_approved_supplier_list_s.NEXTVAL
115: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;
116:
117: l_progress := 15;

Line 114: SET asl_id = po_approved_supplier_list_s.NEXTVAL

110: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
111:
112: --Populate asl ids in case of create
113: UPDATE po_approved_supplier_list_gt GT
114: SET asl_id = po_approved_supplier_list_s.NEXTVAL
115: WHERE GT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE;
116:
117: l_progress := 15;
118: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);

Line 122: FROM po_approved_supplier_list_gt PASL

118: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
119:
120: UPDATE po_asl_attributes_gt PAA
121: SET asl_id = (SELECT asl_id
122: FROM po_approved_supplier_list_gt PASL
123: WHERE PASL.user_key = PAA.user_key
124: AND ROWNUM < 2);
125:
126: l_progress := 20;

Line 131: FROM po_approved_supplier_list_gt PASL

127: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
128:
129: UPDATE po_asl_documents_gt PAD
130: SET asl_id = (SELECT asl_id
131: FROM po_approved_supplier_list_gt PASL
132: WHERE PASL.user_key = PAD.user_key
133: AND ROWNUM < 2);
134:
135: l_progress := 25;

Line 140: FROM po_approved_supplier_list_gt PASL

136: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
137:
138: UPDATE chv_authorizations_gt CHV
139: SET reference_id = (SELECT asl_id
140: FROM po_approved_supplier_list_gt PASL
141: WHERE PASL.user_key = CHV.user_key
142: AND ROWNUM < 2);
143:
144: l_progress := 30;

Line 149: FROM po_approved_supplier_list_gt PASL

145: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
146:
147: UPDATE po_supplier_item_capacity_gt PSIC
148: SET asl_id = (SELECT asl_id
149: FROM po_approved_supplier_list_gt PASL
150: WHERE PASL.user_key = PSIC.user_key
151: AND ROWNUM < 2);
152:
153: l_progress := 35;

Line 158: FROM po_approved_supplier_list_gt PASL

154: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
155:
156: UPDATE po_supplier_item_tolerance_gt PSIT
157: SET asl_id = (SELECT asl_id
158: FROM po_approved_supplier_list_gt PASL
159: WHERE PASL.user_key = PSIT.user_key
160: AND ROWNUM < 2);
161:
162: l_progress := 40;

Line 175: 'po_approved_supplier_list_gt' ,

171: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);*/
172:
173: --Reject records if asl exist when mode is Create
174: SELECT user_key ,
175: 'po_approved_supplier_list_gt' ,
176: fnd_message.get_string('PO','DUPLICATE_ASL')
177: BULK COLLECT INTO
178: l_user_key_tbl ,
179: l_entity_name ,

Line 181: FROM po_approved_supplier_list_gt GT

177: BULK COLLECT INTO
178: l_user_key_tbl ,
179: l_entity_name ,
180: l_reject_reason
181: FROM po_approved_supplier_list_gt GT
182: WHERE EXISTS
183: (SELECT asl_id
184: FROM po_approved_supplier_list PASL
185: WHERE (GT.item_id = PASL.item_id

Line 184: FROM po_approved_supplier_list PASL

180: l_reject_reason
181: FROM po_approved_supplier_list_gt GT
182: WHERE EXISTS
183: (SELECT asl_id
184: FROM po_approved_supplier_list PASL
185: WHERE (GT.item_id = PASL.item_id
186: OR GT.category_id = PASL.category_id)
187: AND GT.using_organization_id = PASL.using_organization_id
188: AND (GT.vendor_id = PASL.vendor_id

Line 199: 'po_approved_supplier_list_gt' ,

195: l_entity_name1 := l_entity_name;
196: l_reject_reason1 := l_reject_reason;
197: --Reject records if asl doesn't exist when mode is update.
198: SELECT user_key ,
199: 'po_approved_supplier_list_gt' ,
200: fnd_message.get_string('PO','ASL_DOES_NOT_EXIST')
201: BULK COLLECT INTO
202: l_user_key_tbl ,
203: l_entity_name ,

Line 205: FROM po_approved_supplier_list_gt GT

201: BULK COLLECT INTO
202: l_user_key_tbl ,
203: l_entity_name ,
204: l_reject_reason
205: FROM po_approved_supplier_list_gt GT
206: WHERE NOT EXISTS
207: (SELECT asl_id
208: FROM po_approved_supplier_list PASL
209: WHERE (GT.item_id = PASL.item_id

Line 208: FROM po_approved_supplier_list PASL

204: l_reject_reason
205: FROM po_approved_supplier_list_gt GT
206: WHERE NOT EXISTS
207: (SELECT asl_id
208: FROM po_approved_supplier_list PASL
209: WHERE (GT.item_id = PASL.item_id
210: OR GT.category_id = PASL.category_id)
211: AND GT.using_organization_id = PASL.using_organization_id
212: AND (GT.vendor_id = PASL.vendor_id

Line 232: po_approved_supplier_list_gt ASLGT

228: l_user_key_tbl ,
229: l_entity_name ,
230: l_reject_reason
231: FROM po_asl_attributes_gt PAAGT,
232: po_approved_supplier_list_gt ASLGT
233: WHERE EXISTS
234: (SELECT 1
235: FROM po_asl_attributes PAA
236: WHERE PAAGT.asl_id = PAA.asl_id

Line 257: po_approved_supplier_list_gt ASLGT

253: l_user_key_tbl ,
254: l_entity_name ,
255: l_reject_reason
256: FROM po_asl_attributes_gt PAAGT,
257: po_approved_supplier_list_gt ASLGT
258: WHERE 2 <=
259: (SELECT Count(user_key)
260: FROM po_asl_attributes_gt PAA
261: WHERE PAAGT.asl_id = PAA.asl_id

Line 282: po_approved_supplier_list_gt ASLGT

278: l_user_key_tbl ,
279: l_entity_name ,
280: l_reject_reason
281: FROM po_asl_attributes_gt PAAGT,
282: po_approved_supplier_list_gt ASLGT
283: WHERE NOT EXISTS
284: (SELECT 1
285: FROM po_asl_attributes PAA
286: WHERE PAAGT.asl_id = PAA.asl_id

Line 307: po_approved_supplier_list_gt ASLGT

303: l_user_key_tbl ,
304: l_entity_name ,
305: l_reject_reason
306: FROM po_asl_documents_gt DOCGT,
307: po_approved_supplier_list_gt ASLGT
308: WHERE EXISTS
309: (SELECT 1
310: FROM po_asl_documents PAD
311: WHERE DOCGT.document_header_id = PAD.document_header_id

Line 332: po_approved_supplier_list_gt ASLGT

328: l_user_key_tbl ,
329: l_entity_name ,
330: l_reject_reason
331: FROM po_asl_documents_gt DOCGT,
332: po_approved_supplier_list_gt ASLGT
333: WHERE NOT EXISTS
334: (SELECT 1
335: FROM po_asl_documents PAD
336: WHERE DOCGT.document_header_id = PAD.document_header_id

Line 358: po_approved_supplier_list_gt ASLGT

354: l_user_key_tbl ,
355: l_entity_name ,
356: l_reject_reason
357: FROM po_asl_documents_gt DOCGT,
358: po_approved_supplier_list_gt ASLGT
359: WHERE 2 <=
360: (SELECT Count(user_key)
361: FROM po_asl_documents_gt PAD
362: WHERE DOCGT.document_header_id = PAD.document_header_id

Line 383: po_approved_supplier_list_gt ASLGT

379: l_user_key_tbl ,
380: l_entity_name ,
381: l_reject_reason
382: FROM chv_authorizations_gt CHVGT,
383: po_approved_supplier_list_gt ASLGT
384: WHERE EXISTS
385: (SELECT 1
386: FROM chv_authorizations CHV
387: WHERE CHVGT.reference_id = CHV.reference_id

Line 411: po_approved_supplier_list_gt ASLGT

407: l_user_key_tbl ,
408: l_entity_name ,
409: l_reject_reason
410: FROM chv_authorizations_gt CHVGT,
411: po_approved_supplier_list_gt ASLGT
412: WHERE NOT EXISTS
413: (SELECT 1
414: FROM chv_authorizations CHV
415: WHERE CHVGT.reference_id = CHV.reference_id

Line 439: po_approved_supplier_list_gt ASLGT

435: l_user_key_tbl ,
436: l_entity_name ,
437: l_reject_reason
438: FROM chv_authorizations_gt CHVGT ,
439: po_approved_supplier_list_gt ASLGT
440: WHERE 2 <=
441: (SELECT Count(user_key)
442: FROM chv_authorizations_gt CHV
443: WHERE CHVGT.reference_id = CHV.reference_id

Line 473: po_approved_supplier_list_gt ASLGT

469: l_user_key_tbl ,
470: l_entity_name ,
471: l_reject_reason
472: FROM po_supplier_item_capacity_gt CAPGT ,
473: po_approved_supplier_list_gt ASLGT
474: WHERE NOT EXISTS
475: (SELECT 1
476: FROM po_supplier_item_capacity CAP
477: WHERE CAPGT.asl_id = CAP.asl_id

Line 503: po_approved_supplier_list_gt ASLGT

499: l_user_key_tbl ,
500: l_entity_name ,
501: l_reject_reason
502: FROM po_supplier_item_tolerance_gt TOLGT,
503: po_approved_supplier_list_gt ASLGT
504: WHERE EXISTS
505: (SELECT 1
506: FROM po_supplier_item_tolerance TOL
507: WHERE TOLGT.asl_id = TOL.asl_id

Line 529: po_approved_supplier_list_gt ASLGT

525: l_user_key_tbl ,
526: l_entity_name ,
527: l_reject_reason
528: FROM po_supplier_item_tolerance_gt TOLGT,
529: po_approved_supplier_list_gt ASLGT
530: WHERE NOT EXISTS
531: (SELECT 1
532: FROM po_supplier_item_tolerance TOL
533: WHERE TOLGT.asl_id = TOL.asl_id

Line 556: po_approved_supplier_list_gt ASLGT

552: l_user_key_tbl ,
553: l_entity_name ,
554: l_reject_reason
555: FROM po_supplier_item_tolerance_gt TOLGT,
556: po_approved_supplier_list_gt ASLGT
557: WHERE 2 <=
558: (SELECT Count(user_key)
559: FROM po_supplier_item_tolerance_gt TOL
560: WHERE TOLGT.asl_id = TOL.asl_id

Line 646: -- This will validate data in po_approved_supplier_list_gt table

642:
643: --Name: validate_asl_gt
644:
645: --Function:
646: -- This will validate data in po_approved_supplier_list_gt table
647:
648: --Parameters:
649:
650: --OUT:

Line 683: 'po_approved_supplier_list_gt' AS entity ,

679: l_reject_reason
680: FROM (
681: --Reject records if item and category both exists for the same ASL
682: SELECT user_key ,
683: 'po_approved_supplier_list_gt' AS entity ,
684: fnd_message.get_string('PO','ITEM_CATEGORY_BOTH_EXIST') AS msg
685: FROM po_approved_supplier_list_gt ASLGT
686: WHERE ASLGT.item_id IS NOT NULL
687: AND ASLGT.category_id IS NOT NULL

Line 685: FROM po_approved_supplier_list_gt ASLGT

681: --Reject records if item and category both exists for the same ASL
682: SELECT user_key ,
683: 'po_approved_supplier_list_gt' AS entity ,
684: fnd_message.get_string('PO','ITEM_CATEGORY_BOTH_EXIST') AS msg
685: FROM po_approved_supplier_list_gt ASLGT
686: WHERE ASLGT.item_id IS NOT NULL
687: AND ASLGT.category_id IS NOT NULL
688:
689: UNION ALL

Line 692: 'po_approved_supplier_list_gt' AS entity ,

688:
689: UNION ALL
690: --Reject records if item and category both empty
691: SELECT user_key ,
692: 'po_approved_supplier_list_gt' AS entity ,
693: fnd_message.get_string('PO','ITEM_CATEGORY_BOTH_EMPTY') AS msg
694: FROM po_approved_supplier_list_gt ASLGT
695: WHERE (ASLGT.item_id IS NULL
696: AND ASLGT.category_id IS NULL)

Line 694: FROM po_approved_supplier_list_gt ASLGT

690: --Reject records if item and category both empty
691: SELECT user_key ,
692: 'po_approved_supplier_list_gt' AS entity ,
693: fnd_message.get_string('PO','ITEM_CATEGORY_BOTH_EMPTY') AS msg
694: FROM po_approved_supplier_list_gt ASLGT
695: WHERE (ASLGT.item_id IS NULL
696: AND ASLGT.category_id IS NULL)
697: OR (Trim(ASLGT.item_id) IS NULL
698: AND Trim(ASLGT.category_id) IS NULL)

Line 703: 'po_approved_supplier_list_gt' AS entity ,

699:
700: UNION ALL
701: --Reject records if vendor business type is empty or null
702: SELECT user_key ,
703: 'po_approved_supplier_list_gt' AS entity ,
704: fnd_message.get_string('PO','INVALID_BUSINESS_TYPE') AS msg
705: FROM po_approved_supplier_list_gt ASLGT
706: WHERE ASLGT.vendor_business_type IS NULL
707: OR Upper(ASLGT.vendor_business_type) NOT IN

Line 705: FROM po_approved_supplier_list_gt ASLGT

701: --Reject records if vendor business type is empty or null
702: SELECT user_key ,
703: 'po_approved_supplier_list_gt' AS entity ,
704: fnd_message.get_string('PO','INVALID_BUSINESS_TYPE') AS msg
705: FROM po_approved_supplier_list_gt ASLGT
706: WHERE ASLGT.vendor_business_type IS NULL
707: OR Upper(ASLGT.vendor_business_type) NOT IN
708: (SELECT lookup_code
709: FROM po_lookup_codes

Line 715: 'po_approved_supplier_list_gt' AS entity ,

711:
712: UNION ALL
713: --Reject records if vendor_id is empty
714: SELECT user_key ,
715: 'po_approved_supplier_list_gt' AS entity ,
716: fnd_message.get_string('PO','VENDOR_EMPTY') AS msg
717: FROM po_approved_supplier_list_gt ASLGT
718: WHERE ASLGT.vendor_id IS NULL
719: AND Upper(vendor_business_type) <> 'MANUFACTURER'

Line 717: FROM po_approved_supplier_list_gt ASLGT

713: --Reject records if vendor_id is empty
714: SELECT user_key ,
715: 'po_approved_supplier_list_gt' AS entity ,
716: fnd_message.get_string('PO','VENDOR_EMPTY') AS msg
717: FROM po_approved_supplier_list_gt ASLGT
718: WHERE ASLGT.vendor_id IS NULL
719: AND Upper(vendor_business_type) <> 'MANUFACTURER'
720:
721: UNION ALL

Line 724: 'po_approved_supplier_list_gt' AS entity ,

720:
721: UNION ALL
722: --Reject records if status_id is empty
723: SELECT user_key ,
724: 'po_approved_supplier_list_gt' AS entity ,
725: fnd_message.get_string('PO','STATUS_EMPTY') AS msg
726: FROM po_approved_supplier_list_gt ASLGT
727: WHERE ASLGT.asl_status_id IS NULL
728: );

Line 726: FROM po_approved_supplier_list_gt ASLGT

722: --Reject records if status_id is empty
723: SELECT user_key ,
724: 'po_approved_supplier_list_gt' AS entity ,
725: fnd_message.get_string('PO','STATUS_EMPTY') AS msg
726: FROM po_approved_supplier_list_gt ASLGT
727: WHERE ASLGT.asl_status_id IS NULL
728: );
729:
730: l_progress := 30;

Line 743: 'po_approved_supplier_list_gt' AS entity ,

739: FROM (
740: --Reject records if manufacturer_asl_id is empty when business type is
741: --'DISTRIBUTOR'
742: SELECT user_key ,
743: 'po_approved_supplier_list_gt' AS entity ,
744: fnd_message.get_string('PO','MANUFACTURER_ASL_MANDATORY') AS msg
745: FROM po_approved_supplier_list_gt ASLGT
746: WHERE ASLGT.manufacturer_asl_id IS NULL
747: AND Upper(ASLGT.vendor_business_type) = 'DISTRIBUTOR'

Line 745: FROM po_approved_supplier_list_gt ASLGT

741: --'DISTRIBUTOR'
742: SELECT user_key ,
743: 'po_approved_supplier_list_gt' AS entity ,
744: fnd_message.get_string('PO','MANUFACTURER_ASL_MANDATORY') AS msg
745: FROM po_approved_supplier_list_gt ASLGT
746: WHERE ASLGT.manufacturer_asl_id IS NULL
747: AND Upper(ASLGT.vendor_business_type) = 'DISTRIBUTOR'
748:
749: UNION ALL

Line 752: 'po_approved_supplier_list_gt' AS entity ,

748:
749: UNION ALL
750: --Reject records if review date entered and is past date
751: SELECT user_key ,
752: 'po_approved_supplier_list_gt' AS entity ,
753: fnd_message.get_string('PO','INVALID_REVIEW_DATE') AS msg
754: FROM po_approved_supplier_list_gt ASLGT
755: WHERE ASLGT.review_by_date IS NOT NULL
756: AND ASLGT.review_by_date < SYSDATE

Line 754: FROM po_approved_supplier_list_gt ASLGT

750: --Reject records if review date entered and is past date
751: SELECT user_key ,
752: 'po_approved_supplier_list_gt' AS entity ,
753: fnd_message.get_string('PO','INVALID_REVIEW_DATE') AS msg
754: FROM po_approved_supplier_list_gt ASLGT
755: WHERE ASLGT.review_by_date IS NOT NULL
756: AND ASLGT.review_by_date < SYSDATE
757:
758: UNION ALL

Line 762: 'po_approved_supplier_list_gt' AS entity ,

758: UNION ALL
759: --During update ASL, business type can't be editable if the value is DB is
760: --'MANUFACTURER'
761: SELECT user_key ,
762: 'po_approved_supplier_list_gt' AS entity ,
763: fnd_message.get_string('PO','BUSINESS_TYPE_NOT_EDITABLE') AS msg
764: FROM po_approved_supplier_list_gt ASLGT
765: WHERE ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
766: AND

Line 764: FROM po_approved_supplier_list_gt ASLGT

760: --'MANUFACTURER'
761: SELECT user_key ,
762: 'po_approved_supplier_list_gt' AS entity ,
763: fnd_message.get_string('PO','BUSINESS_TYPE_NOT_EDITABLE') AS msg
764: FROM po_approved_supplier_list_gt ASLGT
765: WHERE ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
766: AND
767: EXISTS (SELECT asl_id
768: FROM po_approved_supplier_list ASL

Line 768: FROM po_approved_supplier_list ASL

764: FROM po_approved_supplier_list_gt ASLGT
765: WHERE ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
766: AND
767: EXISTS (SELECT asl_id
768: FROM po_approved_supplier_list ASL
769: WHERE ASL.asl_id = ASLGT.asl_id
770: AND Upper(ASL.vendor_business_type) = 'MANUFACTURER')
771: AND Upper(ASLGT.vendor_business_type) <> 'MANUFACTURER'
772:

Line 777: 'po_approved_supplier_list_gt' AS entity ,

773: UNION ALL
774: --Reject records if business type is MANUFACTURER and manufacter id doesn't
775: --exist also reject if vendor exists for the same case
776: SELECT user_key ,
777: 'po_approved_supplier_list_gt' AS entity ,
778: fnd_message.get_string('PO','VENDOR_INVALID_EXP_MANUFACTUR') AS msg
779: FROM po_approved_supplier_list_gt ASLGT
780: WHERE Upper(ASLGT.vendor_business_type) = 'MANUFACTURER'
781: AND (ASLGT.manufacturer_id IS NULL

Line 779: FROM po_approved_supplier_list_gt ASLGT

775: --exist also reject if vendor exists for the same case
776: SELECT user_key ,
777: 'po_approved_supplier_list_gt' AS entity ,
778: fnd_message.get_string('PO','VENDOR_INVALID_EXP_MANUFACTUR') AS msg
779: FROM po_approved_supplier_list_gt ASLGT
780: WHERE Upper(ASLGT.vendor_business_type) = 'MANUFACTURER'
781: AND (ASLGT.manufacturer_id IS NULL
782: OR ASLGT.vendor_id IS NOT NULL)
783: );

Line 802: 'po_approved_supplier_list_gt' AS entity ,

798: FROM (
799: --Reject records when business type is MANUFACTURER and if there are any
800: --child records exist
801: SELECT user_key ,
802: 'po_approved_supplier_list_gt' AS entity ,
803: fnd_message.get_string('PO','MANUFAC_INVALID_AUTH_ENTRY') AS msg
804: FROM po_approved_supplier_list_gt ASLGT
805: WHERE Upper(ASLGT.vendor_business_type) = 'MANUFACTURER'
806: AND

Line 804: FROM po_approved_supplier_list_gt ASLGT

800: --child records exist
801: SELECT user_key ,
802: 'po_approved_supplier_list_gt' AS entity ,
803: fnd_message.get_string('PO','MANUFAC_INVALID_AUTH_ENTRY') AS msg
804: FROM po_approved_supplier_list_gt ASLGT
805: WHERE Upper(ASLGT.vendor_business_type) = 'MANUFACTURER'
806: AND
807: (EXISTS
808: (SELECT 1

Line 1013: po_approved_supplier_list_gt ASLGT

1009: SELECT PAAGT.user_key ,
1010: 'po_asl_attributes_gt' AS entity ,
1011: fnd_message.get_string('PO','INVALID_SUPP_ITEM_CAP_ENTRY') AS msg
1012: FROM po_asl_attributes_gt PAAGT,
1013: po_approved_supplier_list_gt ASLGT
1014: WHERE PAAGT.user_key = ASLGT.user_key
1015: AND ASLGT.using_organization_id <> -1
1016: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1017: AND EXISTS

Line 1119: po_approved_supplier_list_gt ASLGT

1115: SELECT PAAGT.user_key ,
1116: 'po_asl_attributes_gt' AS entity ,
1117: fnd_message.get_string('PO','INVALID_SUPP_ITEM_TOL_ENTRY') AS msg
1118: FROM po_asl_attributes_gt PAAGT,
1119: po_approved_supplier_list_gt ASLGT
1120: WHERE PAAGT.user_key = ASLGT.user_key
1121: AND ASLGT.using_organization_id <> -1
1122: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1123: AND EXISTS

Line 1782: po_approved_supplier_list_gt ASLGT

1778: l_user_key_tbl ,
1779: l_entity_name ,
1780: l_reject_reason
1781: FROM po_supplier_item_capacity_gt PSICGT ,
1782: po_approved_supplier_list_gt ASLGT
1783: WHERE 2 <= (SELECT Count(user_key)
1784: FROM po_supplier_item_capacity_gt PSIC
1785: WHERE (PSICGT.from_date_dsp
1786: BETWEEN PSIC.from_date_dsp AND PSIC.to_date_dsp

Line 1808: po_approved_supplier_list_gt ASLGT

1804: l_user_key_tbl ,
1805: l_entity_name ,
1806: l_reject_reason
1807: FROM po_supplier_item_capacity_gt PSICGT ,
1808: po_approved_supplier_list_gt ASLGT
1809: WHERE EXISTS
1810: (SELECT 1
1811: FROM po_supplier_item_capacity PSIC
1812: WHERE (PSICGT.from_date_dsp

Line 1997: FROM po_approved_supplier_list PASL

1993: SELECT 1 INTO l_found
1994: FROM dual
1995: WHERE EXISTS
1996: (SELECT asl_id
1997: FROM po_approved_supplier_list PASL
1998: WHERE (PASL.item_id = p_item_id
1999: OR PASL.category_id = p_category_id)
2000: AND PASL.using_organization_id = p_using_organization_id
2001: AND PASL.vendor_id = p_vendor_id