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_INTERFACE_S dependencies on PO_RELEASES_ALL

Line 1223: from po_releases_all --

1219: IF g_document_subtype = 'RELEASE' THEN
1220: l_progress:= '130';
1221: select release_num
1222: into x_release_number
1223: from po_releases_all --
1224: where po_release_id=x_document_id;
1225:
1226: x_document_number := interface.document_num || '-' || to_char(x_release_number);
1227:

Line 1320: update po_releases_all

1316:
1317: ELSIF g_document_subtype = 'RELEASE' THEN
1318:
1319: l_progress:= '170';
1320: update po_releases_all
1321: set authorization_status = 'APPROVED',
1322: approved_date = sysdate,
1323: approved_flag = 'Y'
1324: where po_release_id = x_document_id;

Line 1943: FROM po_releases_all --

1939: l_progress:='130';
1940:
1941: SELECT po_release_id
1942: INTO g_po_release_id
1943: FROM po_releases_all --
1944: WHERE release_num = interface.release_num
1945: AND po_header_id = interface.po_header_id
1946: FOR UPDATE OF approved_flag;
1947:

Line 1972: The Approved flag in po_releases all was having null value.

1968: p_token => l_progress,
1969: p_message => 'Update PO_Releases Doc subtype is Release');
1970: END IF;
1971: /*bug 12674183 While trying to add a req line to Blanket Release in Incomplete status
1972: The Approved flag in po_releases all was having null value.
1973: so the value of approved_flag in this update statement was being set to R,
1974: Hence added NVL condition for Approved_flag.*/
1975: UPDATE PO_RELEASES_ALL --
1976: SET last_update_date = interface.last_update_date,

Line 1975: UPDATE PO_RELEASES_ALL --

1971: /*bug 12674183 While trying to add a req line to Blanket Release in Incomplete status
1972: The Approved flag in po_releases all was having null value.
1973: so the value of approved_flag in this update statement was being set to R,
1974: Hence added NVL condition for Approved_flag.*/
1975: UPDATE PO_RELEASES_ALL --
1976: SET last_update_date = interface.last_update_date,
1977: last_updated_by = interface.last_updated_by,
1978: last_update_login = interface.last_update_login,
1979: closed_code = 'OPEN',

Line 2490: -- insert it into po_releases_all instead of p_document_creation_method

2486: */
2487: l_progress:='280';
2488:
2489: -- Bug 3599251: Assign value to l_document_creation_method and
2490: -- insert it into po_releases_all instead of p_document_creation_method
2491: -- Bug 3648268 Use lookup code instead of hardcoded value
2492: IF g_interface_source_code = 'CONSUMPTION_ADVICE' THEN
2493: l_document_creation_method := 'CREATE_CONSUMPTION';
2494: END IF;

Line 2502: INSERT INTO po_releases_all --

2498: p_token => l_progress,
2499: p_message => 'Before insert into PO_RELEASES');
2500: END IF;
2501:
2502: INSERT INTO po_releases_all --
2503: (po_release_id,
2504: last_update_date,
2505: last_updated_by,
2506: po_header_id,

Line 2780: from po_releases_all por --

2776: begin
2777: l_progress := '380';
2778: select nvl(max(release_num),0) + 1
2779: into x_release_num
2780: from po_releases_all por --
2781: where por.po_header_id = interface.po_header_id;
2782: /*Bug 1724603
2783: When we are creating a blanket release for the first time then
2784: we end up creating releases with negative release numbers

Line 2794: update po_releases_all --

2790: x_release_num := 1;
2791: end if;
2792:
2793: l_progress := '390';
2794: update po_releases_all --
2795: set release_num = x_release_num
2796: where po_releases_all.po_header_id = interface.po_header_id
2797: and release_num = -g_po_release_id;
2798: exit;

Line 2796: where po_releases_all.po_header_id = interface.po_header_id

2792:
2793: l_progress := '390';
2794: update po_releases_all --
2795: set release_num = x_release_num
2796: where po_releases_all.po_header_id = interface.po_header_id
2797: and release_num = -g_po_release_id;
2798: exit;
2799: exception
2800: when DUP_VAL_ON_INDEX then

Line 5993: po_releases_all por --

5989: l_manual_price_change_flag, --bug 3495772
5990: x_secondary_unit_of_measure
5991: FROM po_line_locations_all poll, --
5992: po_lines_all pol, --
5993: po_releases_all por --
5994: WHERE poll.po_header_id = interface.po_header_id
5995: AND poll.po_line_id = pol.po_line_id
5996: AND poll.shipment_num = interface.shipment_num
5997: AND pol.line_num = interface.line_num

Line 9258: l_shipping_control PO_RELEASES_ALL.shipping_control%TYPE; --

9254: x_requestor_location_id number;
9255: x_location_code varchar2(25);
9256: x_employee_is_buyer boolean;
9257: x_is_emp boolean;
9258: l_shipping_control PO_RELEASES_ALL.shipping_control%TYPE; --
9259:
9260: Cursor C is select pli.rowid,
9261: pli.item_id,
9262: phi.vendor_id,

Line 11157: po_releases_all pr

11153: SELECT nvl(max(poll.shipment_num),0)
11154: INTO x_shipment_num
11155: FROM po_headers_all ph,
11156: po_line_locations_all poll,
11157: po_releases_all pr
11158: WHERE ph.po_header_id = poll.po_header_id
11159: AND ph.segment1 = x_document_num
11160: AND pr.po_header_id = ph.po_header_id
11161: AND pr.release_num = x_release_num

Line 12839: FROM po_releases_all por, --

12835: BEGIN
12836:
12837: SELECT por.po_release_id
12838: INTO g_po_release_id
12839: FROM po_releases_all por, --
12840: po_headers_interface phi
12841: WHERE phi.interface_header_id = x_interface_header_id
12842: AND phi.release_num = por.release_num
12843: AND phi.po_header_id = por.po_header_id

Line 13620: po_releases_all pr --

13616: select nvl(max(shipment_num),0)
13617: into x_shipment_num
13618: from po_headers_all ph, --
13619: po_line_locations_all poll, --
13620: po_releases_all pr --
13621: where ph.po_header_id = poll.po_header_id
13622: and ph.segment1 = x_document_num
13623: and pr.po_header_id = ph.po_header_id
13624: and pr.release_num = x_release_num