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_CL_SUPPLIER_RESP dependencies on MSC_ST_SUPPLIES

Line 38: ' insert into MSC_ST_SUPPLIES'

34:
35: IF (p_supplier_response_flag = SYS_YES) THEN
36:
37: v_sql_stmt:=
38: ' insert into MSC_ST_SUPPLIES'
39: ||' ( INVENTORY_ITEM_ID,'
40: ||' ORGANIZATION_ID,'
41: ||' DISPOSITION_ID,'
42: ||' SUPPLIER_ID,'

Line 109: LOG_MESSAGE('Error while populating msc_st_supplies from MRP_AP_SUPPLIER_RESPONSE_V');

105:
106: COMMIT;
107:
108: EXCEPTION WHEN OTHERS THEN
109: LOG_MESSAGE('Error while populating msc_st_supplies from MRP_AP_SUPPLIER_RESPONSE_V');
110: LOG_MESSAGE(SQLERRM);
111: p_return_status := FALSE;
112: END;
113:

Line 147: from msc_st_supplies mss,

143: mss.END_ORDER_SHIPMENT_NUMBER,
144: mss.ACCEPTANCE_REQUIRED_FLAG,
145: mss.NEED_BY_DATE,
146: mss.ACK_REFERENCE_NUMBER
147: from msc_st_supplies mss,
148: msc_tp_id_lid mtil,
149: msc_tp_site_id_lid mtsil,
150: msc_item_id_lid miil
151: where mss.order_type = G_MRP_PO_ACK

Line 190: prev_po_number msc_st_supplies.end_order_number%TYPE;

186: a_need_by_date dates :=dates();
187: a_acceptance_required_flag acceptance_required_flags := acceptance_required_flags();
188: a_ack_reference_number ack_reference_numbers := ack_reference_numbers();
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;

Line 191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;

187: a_acceptance_required_flag acceptance_required_flags := acceptance_required_flags();
188: a_ack_reference_number ack_reference_numbers := ack_reference_numbers();
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:

Line 192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;

188: a_ack_reference_number ack_reference_numbers := ack_reference_numbers();
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;

Line 193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;

189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;

Line 194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;

190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;

Line 196: curr_po_number msc_st_supplies.end_order_number%TYPE;

192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;

Line 197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;

193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:

Line 198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;

194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
202: order_line_number VARCHAR2(40);

Line 199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;

195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
202: order_line_number VARCHAR2(40);
203: lv_temp_supply_tbl VARCHAR2(40);

Line 200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;

196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
202: order_line_number VARCHAR2(40);
203: lv_temp_supply_tbl VARCHAR2(40);
204:

Line 231: -- For the records collected from msc_st_supplies

227: lv_sql_stmt VARCHAR2(5000);
228:
229: BEGIN
230: --======================================================================
231: -- For the records collected from msc_st_supplies
232: -- delete the corresponding previous "PO Acknowledgment" records for the
233: -- following key
234: --
235: -- sr_instance_id,