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.MSC_X_NETTING3_PKG dependencies on MSC_X_EXCEPTION_DETAILS

Line 495: FROM msc_x_exception_details

491: CURSOR get_delete_row (p_transaction_id IN NUMBER) IS
492: SELECT company_id, company_site_id, customer_id, customer_site_id,
493: supplier_id, supplier_site_id, inventory_item_id,
494: transaction_id1, transaction_id2
495: FROM msc_x_exception_details
496: WHERE plan_id = -1
497: AND exception_type in (msc_x_netting_pkg.G_EXCEP50,msc_x_netting_pkg.G_EXCEP51)
498: AND transaction_id2 = p_transaction_id;
499:

Line 667: AND not exists (SELECT * FROM msc_x_exception_details d

663: AND r.relationship_type = 2
664: AND map3.map_type = 3
665: AND map3.company_key = sd1.supplier_site_id
666: AND itm.inventory_item_id = sd1.inventory_item_id
667: AND not exists (SELECT * FROM msc_x_exception_details d
668: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3
669: AND d.transaction_id1 = sd1.transaction_id)
670: AND nvl(sd1.last_refresh_number,-1) > nvl(p_refresh_number,-1)
671: ORDER BY sd1.publisher_id, sd1.publisher_site_id, sd1.supplier_id, sd1.supplier_site_id, sd1.inventory_item_id;

Line 709: AND not exists (SELECT * FROM msc_x_exception_details d

705: sd1.creation_date
706: FROM msc_sup_dem_entries sd1
707: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
708: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
709: AND not exists (SELECT * FROM msc_x_exception_details d
710: WHERE d.exception_type in (3,12)
711: AND d.transaction_id1 = sd1.transaction_id)
712: AND sd1.last_refresh_number > p_refresh_number
713: ORDER BY sd1.publisher_id, sd1.publisher_site_id, sd1.customer_id, sd1.customer_site_id, sd1.inventory_item_id ;

Line 774: from msc_x_exception_details

770: company_site_id,
771: exception_group,
772: exception_type,
773: count(*)
774: from msc_x_exception_details
775: where plan_id =msc_x_netting_pkg.G_PLAN_ID
776: and version = 'X'
777: and exception_type in (11,12,31,32)
778: group by plan_id,

Line 852: l_exception_basis msc_x_exception_details.exception_basis%type;

848: l_item_type Varchar2(20);
849: l_item_key Varchar2(100);
850: l_row Number;
851: l_shipping_control Number;
852: l_exception_basis msc_x_exception_details.exception_basis%type;
853:
854: l_inserted_record Number;
855:
856: --------------------------------------------------------

Line 887: update msc_x_exception_details

883: Set version = 'CURRENT'
884: And archive the msc_item_exceptions
885: =====================================================*/
886:
887: update msc_x_exception_details
888: set version = 'X'
889: where plan_id = msc_x_netting_pkg.G_PLAN_ID
890: and exception_type in (11,12,31,32);
891:

Line 965: update msc_x_exception_details

961: b_trx_id1(j));
962: IF (l_exception_detail_id1 > 0 ) then
963: --dbms_output.put_line('----Detail exist for trx_id '||b_trx_id1(j));
964: --reset version=null indicate no need to resend notification
965: update msc_x_exception_details
966: set version = null,
967: threshold = b_threshold1(j),
968: date1 = b_po_receipt_date(j),
969: date2 = b_po_ship_date(j),

Line 1095: update msc_x_exception_details

1091: b_trx_id1(j));
1092: IF (l_exception_detail_id2 > 0 ) then
1093: --dbms_output.put_line('----Detail exist for trx_id '||b_trx_id1(j));
1094: --reset version=null indicate no need to resend notification
1095: update msc_x_exception_details
1096: set version = null,
1097: threshold = b_threshold2(j),
1098: date1 = b_po_receipt_date(j),
1099: date2 = b_po_ship_date(j),

Line 1284: update msc_x_exception_details

1280:
1281: IF (l_exception_detail_id1 > 0 ) then
1282: --dbms_output.put_line('----Detail exist for trx_id '||b_trx_id1(j));
1283: --reset version=null indicate no need to resend notification
1284: update msc_x_exception_details
1285: set version = null,
1286: threshold = b_threshold1(j),
1287: date1 = b_so_ship_date(j),
1288: date2 = b_so_receipt_date(j),

Line 1421: update msc_x_exception_details

1417:
1418: IF (l_exception_detail_id2 > 0 ) then
1419: --dbms_output.put_line('----Detail exist for trx_id '||b_trx_id1(j));
1420: --reset version=null indicate no need to resend notification
1421: update msc_x_exception_details
1422: set version = null,
1423: threshold = b_threshold2(j),
1424: date1 = b_so_ship_date(j),
1425: date2 = b_so_receipt_date(j),

Line 1543: --The old exceptions with version = 'X' in msc_x_exception_details table

1539: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_RESPONSE_REQUIRED) || ':' || l_inserted_record);
1540: --===========================================================================================
1541: --Archive all the exception notifications sent out in previous engine runs
1542: --and are not re-occurr in this run
1543: --The old exceptions with version = 'X' in msc_x_exception_details table
1544: --=======================================================================================
1545: BEGIN
1546: delete msc_x_exception_details
1547: where plan_id = msc_x_netting_pkg.G_PLAN_ID

Line 1546: delete msc_x_exception_details

1542: --and are not re-occurr in this run
1543: --The old exceptions with version = 'X' in msc_x_exception_details table
1544: --=======================================================================================
1545: BEGIN
1546: delete msc_x_exception_details
1547: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1548: and exception_type in (11,12,31,32)
1549: and version = 'X';
1550:

Line 1849: l_exception_basis msc_x_exception_details.exception_basis%type;

1845: l_po_receipt_date Date;
1846: l_so_key_date Date;
1847: l_po_key_date Date;
1848: l_shipping_control Number;
1849: l_exception_basis msc_x_exception_details.exception_basis%type;
1850:
1851: l_ascp_demand_order_number msc_demands.order_number%type;
1852: l_ascp_so_line_id Number;
1853: l_ascp_reservation_id Number;

Line 3388: FROM msc_x_exception_details d

3384: IF (b_po_key_date(j) + l_threshold < b_po_creation_date(j) + b_lead_time(j) + l_transit_time) THEN
3385:
3386: SELECT count(*)
3387: into l_count
3388: FROM msc_x_exception_details d
3389: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP4
3390: AND d.transaction_id1 = b_trx_id1(j);
3391:
3392: IF (l_count > 0) THEN

Line 3507: FROM msc_x_exception_details d

3503: l_count := 0;
3504:
3505: SELECT count(*)
3506: INTO l_count
3507: FROM msc_x_exception_details d
3508: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3
3509: AND d.transaction_id1 = b_trx_id1(j);
3510:
3511: IF (l_count > 0 ) THEN