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_SYNCH dependencies on PO_LINE_LOCATIONS_ALL

Line 307: FROM po_line_locations_all

303:
304: IF v_transaction_type in ( 'BLANKET','PLANNED') THEN
305: SELECT shipment_num
306: INTO v_line_no
307: FROM po_line_locations_all
308: WHERE line_location_id = v_po_line_location_id;
309:
310: /* If it is a standard PO, we'll retain the line number from apps as long as
311: there is only one shipment per line.We'll generate a number if there is

Line 322: FROM po_line_locations_all

318: WHERE po_header_id = v_po_header_id;
319:
320: SELECT count(*)
321: INTO v_shipment_count
322: FROM po_line_locations_all
323: WHERE po_header_id = v_po_header_id;
324:
325: IF v_line_count = v_shipment_count THEN
326: SELECT line_num

Line 557: FROM po_line_locations_all

553: WHERE po_line_id = v_line_id;
554:
555: CURSOR shipment_cur IS
556: SELECT shipment_num
557: FROM po_line_locations_all
558: WHERE line_location_id = v_line_location_id;
559:
560: v_err_message VARCHAR2(2000);
561:

Line 1424: CURSOR attr_dtl_cur(v_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,

1420: attribute14
1421: FROM PO_HEADERS_ALL
1422: WHERE PO_HEADER_ID = v_po_ordr_header_id;
1423:
1424: CURSOR attr_dtl_cur(v_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1425: v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1426: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE)
1427: IS
1428: SELECT attribute1,

Line 1425: v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,

1421: FROM PO_HEADERS_ALL
1422: WHERE PO_HEADER_ID = v_po_ordr_header_id;
1423:
1424: CURSOR attr_dtl_cur(v_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1425: v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1426: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE)
1427: IS
1428: SELECT attribute1,
1429: attribute2,

Line 1426: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE)

1422: WHERE PO_HEADER_ID = v_po_ordr_header_id;
1423:
1424: CURSOR attr_dtl_cur(v_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1425: v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1426: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE)
1427: IS
1428: SELECT attribute1,
1429: attribute2,
1430: attribute3,

Line 1443: FROM PO_LINE_LOCATIONS_ALL

1439: attribute12,
1440: attribute13,
1441: attribute14,
1442: attribute15
1443: FROM PO_LINE_LOCATIONS_ALL
1444: WHERE LINE_LOCATION_ID = v_line_locations_id
1445: AND PO_HEADER_ID = v_ordr_header_id
1446: AND PO_LINE_ID = v_po_line_id;
1447:

Line 1455: ( v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,

1451: /* END BUG#1731582 */
1452:
1453: /* Uday Phadtare B2085936 */
1454: CURSOR po_lines_all_cur
1455: ( v_ordr_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1456: v_line_id PO_LINES_ALL.po_line_id%TYPE) IS
1457: SELECT substrb(item_description,1,70)
1458: FROM po_lines_all
1459: WHERE po_header_id = v_ordr_header_id

Line 1637: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;

1633:
1634: -- Bug 1882830, lswamy
1635: -- Should not check for inventory period, if po is closed at Apps end.
1636:
1637: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
1638:
1639: CURSOR po_line_locns_cur(v_po_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1640: v_po_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1641: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE) IS

Line 1639: CURSOR po_line_locns_cur(v_po_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,

1635: -- Should not check for inventory period, if po is closed at Apps end.
1636:
1637: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
1638:
1639: CURSOR po_line_locns_cur(v_po_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1640: v_po_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1641: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE) IS
1642:
1643: SELECT closed_code

Line 1640: v_po_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,

1636:
1637: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
1638:
1639: CURSOR po_line_locns_cur(v_po_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1640: v_po_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1641: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE) IS
1642:
1643: SELECT closed_code
1644: FROM po_line_locations_all

Line 1641: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE) IS

1637: v_closed_code PO_LINE_LOCATIONS_ALL.CLOSED_CODE%TYPE;
1638:
1639: CURSOR po_line_locns_cur(v_po_line_locations_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE,
1640: v_po_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1641: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE) IS
1642:
1643: SELECT closed_code
1644: FROM po_line_locations_all
1645: WHERE po_header_id = v_po_header_id

Line 1644: FROM po_line_locations_all

1640: v_po_header_id PO_LINE_LOCATIONS_ALL.PO_HEADER_ID%TYPE,
1641: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE) IS
1642:
1643: SELECT closed_code
1644: FROM po_line_locations_all
1645: WHERE po_header_id = v_po_header_id
1646: AND po_line_id = v_po_line_id
1647: AND line_location_id = v_po_line_locations_id;
1648: -- End bug1882830.