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_SUPPLIER_ITEM_TOLERANCE

Line 156: UPDATE po_supplier_item_tolerance_gt PSIT

152:
153: l_progress := 35;
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);

Line 496: 'po_supplier_item_tolerance_gt' ,

492: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
493: --Reject records if tolerance process mode is add, asl mode is update
494: --and record already exists for that org
495: SELECT TOLGT.user_key ,
496: 'po_supplier_item_tolerance_gt' ,
497: fnd_message.get_string('PO','DUPLICATE_TOLERANCE')
498: BULK COLLECT INTO
499: l_user_key_tbl ,
500: l_entity_name ,

Line 502: FROM po_supplier_item_tolerance_gt TOLGT,

498: BULK COLLECT INTO
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

Line 506: FROM po_supplier_item_tolerance TOL

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
508: AND TOLGT.using_organization_id = TOL.using_organization_id
509: AND TOLGT.number_of_days_dsp = TOL.number_of_days
510: )

Line 522: 'po_supplier_item_tolerance_gt' ,

518: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
519: --Reject records if tolerance process mode is delete, asl mode is update
520: --and record does not exist for that org
521: SELECT TOLGT.user_key ,
522: 'po_supplier_item_tolerance_gt' ,
523: fnd_message.get_string('PO','TOLERANCE_NOT_EXIST')
524: BULK COLLECT INTO
525: l_user_key_tbl ,
526: l_entity_name ,

Line 528: FROM po_supplier_item_tolerance_gt TOLGT,

524: BULK COLLECT INTO
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

Line 532: FROM po_supplier_item_tolerance TOL

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
534: AND TOLGT.using_organization_id = TOL.using_organization_id
535: AND TOLGT.number_of_days_dsp = TOL.number_of_days
536: )

Line 549: 'po_supplier_item_tolerance_gt' ,

545: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
546: --Reject records if tolerance process mode is add, asl mode is create
547: --and authorization code or sequence already exists for that org
548: SELECT TOLGT.user_key ,
549: 'po_supplier_item_tolerance_gt' ,
550: fnd_message.get_string('PO','DUPLICATE_TOLERANCE')
551: BULK COLLECT INTO
552: l_user_key_tbl ,
553: l_entity_name ,

Line 555: FROM po_supplier_item_tolerance_gt TOLGT,

551: BULK COLLECT INTO
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

Line 559: FROM po_supplier_item_tolerance_gt TOL

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
561: AND TOLGT.using_organization_id = TOL.using_organization_id
562: AND TOLGT.number_of_days_dsp = TOL.number_of_days_dsp
563: )

Line 833: FROM po_supplier_item_tolerance_gt PSIT

829: AND PSIC.user_key = ASLGT.user_key)
830: OR
831: EXISTS
832: (SELECT 1
833: FROM po_supplier_item_tolerance_gt PSIT
834: WHERE PSIT.asl_id = ASLGT.asl_id
835: AND PSIT.user_key = ASLGT.user_key)));
836:
837: l_progress := 90;

Line 1113: --Reject records if there is an entry in po_supplier_item_tolerance_gt

1109: AND CHV.user_key = PAAGT.user_key
1110: AND CHV.process_action = PO_ASL_API_PUB.g_ACTION_ADD)
1111: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1112: UNION ALL
1113: --Reject records if there is an entry in po_supplier_item_tolerance_gt
1114: -- when global_flag is N and VMI flag is not checked
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

Line 1125: FROM po_supplier_item_tolerance_gt PSIT

1121: AND ASLGT.using_organization_id <> -1
1122: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1123: AND EXISTS
1124: (SELECT 1
1125: FROM po_supplier_item_tolerance_gt PSIT
1126: WHERE PSIT.asl_id = PAAGT.asl_id
1127: AND PSIT.using_organization_id= PAAGT.using_organization_id
1128: AND PSIT.user_key = PAAGT.user_key
1129: AND PSIT.process_action = PO_ASL_API_PUB.g_ACTION_ADD)

Line 1862: -- This will validate data in po_supplier_item_tolerance_gt table

1858:
1859: --Name: validate_supp_item_tol_gt
1860:
1861: --Function:
1862: -- This will validate data in po_supplier_item_tolerance_gt table
1863:
1864: --Parameters:
1865:
1866: --OUT:

Line 1896: 'po_supplier_item_tolerance_gt' AS entity,

1892: l_reject_reason
1893: FROM (
1894: --Reject records if number_of_days_dsp is less than 1
1895: SELECT user_key ,
1896: 'po_supplier_item_tolerance_gt' AS entity,
1897: fnd_message.get_string('PO','INVALID_NUM_OF_DAYS') AS msg
1898: FROM po_supplier_item_tolerance_gt PSITGT
1899: WHERE PSITGT.number_of_days_dsp IS NULL
1900: OR PSITGT.number_of_days_dsp <= 0

Line 1898: FROM po_supplier_item_tolerance_gt PSITGT

1894: --Reject records if number_of_days_dsp is less than 1
1895: SELECT user_key ,
1896: 'po_supplier_item_tolerance_gt' AS entity,
1897: fnd_message.get_string('PO','INVALID_NUM_OF_DAYS') AS msg
1898: FROM po_supplier_item_tolerance_gt PSITGT
1899: WHERE PSITGT.number_of_days_dsp IS NULL
1900: OR PSITGT.number_of_days_dsp <= 0
1901:
1902: UNION ALL

Line 1905: 'po_supplier_item_tolerance_gt' AS entity,

1901:
1902: UNION ALL
1903: --Reject records if tolerance_dsp is less than 1
1904: SELECT user_key ,
1905: 'po_supplier_item_tolerance_gt' AS entity,
1906: fnd_message.get_string('PO','INVALID_TOLERANCE') AS msg
1907: FROM po_supplier_item_tolerance_gt PSITGT
1908: WHERE PSITGT.tolerance_dsp IS NULL
1909: OR PSITGT.tolerance_dsp <= 0

Line 1907: FROM po_supplier_item_tolerance_gt PSITGT

1903: --Reject records if tolerance_dsp is less than 1
1904: SELECT user_key ,
1905: 'po_supplier_item_tolerance_gt' AS entity,
1906: fnd_message.get_string('PO','INVALID_TOLERANCE') AS msg
1907: FROM po_supplier_item_tolerance_gt PSITGT
1908: WHERE PSITGT.tolerance_dsp IS NULL
1909: OR PSITGT.tolerance_dsp <= 0
1910: );
1911: