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.GML_PO_INTERFACE dependencies on PO_LINE_LOCATIONS_ALL

Line 104: po_line_locations_all table*/

100:
101: v_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
102:
103: /* Definitions for variables that are derived from columns of
104: po_line_locations_all table*/
105:
106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;
107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;

Line 106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;

102:
103: /* Definitions for variables that are derived from columns of
104: po_line_locations_all table*/
105:
106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;
107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;

Line 107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;

103: /* Definitions for variables that are derived from columns of
104: po_line_locations_all table*/
105:
106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;
107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;

Line 108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;

104: po_line_locations_all table*/
105:
106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;
107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;

Line 109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;

105:
106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;
107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;

Line 110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;

106: v_quantity PO_LINE_LOCATIONS_ALL.QUANTITY%TYPE;
107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;

Line 111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;

107: v_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE;
108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;

Line 112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;

108: v_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;

Line 113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;

109: v_db_promised_date PO_LINE_LOCATIONS_ALL.PROMISED_DATE%TYPE;
110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code

Line 114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;

110: v_last_accept_date PO_LINE_LOCATIONS_ALL.LAST_ACCEPT_DATE%TYPE;
111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;

Line 115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;

111: v_po_release_id PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID%TYPE;
112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;

Line 116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;

112: v_cancel_flag PO_LINE_LOCATIONS_ALL.CANCEL_FLAG%TYPE;
113: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;
120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;

Line 118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;

114: v_fob_lookup_code PO_LINE_LOCATIONS_ALL.FOB_LOOKUP_CODE%TYPE;
115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;
120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;
121: v_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
122:

Line 119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;

115: v_ship_via_lookup_code PO_LINE_LOCATIONS_ALL.SHIP_VIA_LOOKUP_CODE%TYPE;
116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;
120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;
121: v_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
122:
123: /* Bug# 1200791 Added by Preetam Bamb for warehouse changes.*/

Line 120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;

116: v_source_shipment_id PO_LINE_LOCATIONS_ALL.SOURCE_SHIPMENT_ID%TYPE;
117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;
120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;
121: v_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
122:
123: /* Bug# 1200791 Added by Preetam Bamb for warehouse changes.*/
124: v_ship_to_organization_id PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%TYPE;

Line 121: v_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;

117: v_freight_terms_lookup_code
118: PO_LINE_LOCATIONS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
119: v_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%TYPE;
120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;
121: v_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
122:
123: /* Bug# 1200791 Added by Preetam Bamb for warehouse changes.*/
124: v_ship_to_organization_id PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%TYPE;
125:

Line 124: v_ship_to_organization_id PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%TYPE;

120: v_ship_to_location_id PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%TYPE;
121: v_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE;
122:
123: /* Bug# 1200791 Added by Preetam Bamb for warehouse changes.*/
124: v_ship_to_organization_id PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%TYPE;
125:
126: /* Miscellaneous variables */
127:
128: /* H. Wahdani temp. variable to store SY$ZERODATE */

Line 220: /* Cursor to select values from po_line_locations_all table */

216: FROM po_lines_all
217: WHERE po_header_id = p_po_header_id
218: AND po_line_id = p_po_line_id;
219:
220: /* Cursor to select values from po_line_locations_all table */
221: /*Bug# 1200791 */
222: CURSOR lineloc_vars_cur
223: IS
224: SELECT quantity, need_by_date, closed_code,

Line 231: FROM po_line_locations_all

227: source_shipment_id,
228: price_override,
229: nvl(SHIP_TO_ORGANIZATION_ID,0), /*Bug# 1200791 nvl(ship_to_location_id,0) Changed by Preetam for warehouse changes */
230: shipment_num
231: FROM po_line_locations_all
232: WHERE po_header_id = p_po_header_id
233: AND po_line_id = p_po_line_id
234: AND line_location_id = p_po_line_location_id;
235: