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_HEADERS_ALL

Line 44: -- been modified to point to PO_HEADERS_ALL type.

40: (vendor_id number := null,
41: ship_to_location_id number := null,
42: bill_to_location_id number := null,
43: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have
44: -- been modified to point to PO_HEADERS_ALL type.
45: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%type := null,
46: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%type := null,
47: pay_on_code varchar2(25) := null,
48: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%type := null,

Line 45: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%type := null,

41: ship_to_location_id number := null,
42: bill_to_location_id number := null,
43: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have
44: -- been modified to point to PO_HEADERS_ALL type.
45: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%type := null,
46: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%type := null,
47: pay_on_code varchar2(25) := null,
48: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%type := null,
49: terms_id number := null,

Line 46: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%type := null,

42: bill_to_location_id number := null,
43: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have
44: -- been modified to point to PO_HEADERS_ALL type.
45: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%type := null,
46: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%type := null,
47: pay_on_code varchar2(25) := null,
48: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%type := null,
49: terms_id number := null,
50: type_1099 po_vendors.type_1099%type := null,

Line 48: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%type := null,

44: -- been modified to point to PO_HEADERS_ALL type.
45: ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%type := null,
46: fob_lookup_code PO_HEADERS_ALL.fob_lookup_code%type := null,
47: pay_on_code varchar2(25) := null,
48: freight_terms_lookup_code PO_HEADERS_ALL.freight_terms_lookup_code%type := null,
49: terms_id number := null,
50: type_1099 po_vendors.type_1099%type := null,
51: hold_flag po_vendors.hold_flag%type := null,
52: invoice_currency_code po_vendors.invoice_currency_code%type := null,

Line 350: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE; --

346: g_document_subtype po_headers_interface.document_subtype%type := null;
347: g_po_release_id number := null;
348: g_document_type varchar2(25) := null;
349: g_number_records_processed number;
350: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE; --
351: g_hdr_requesting_ou_id PO_HEADERS_ALL.org_id%TYPE; --
352: g_rate_for_req_fields NUMBER; --
353: g_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
354:

Line 351: g_hdr_requesting_ou_id PO_HEADERS_ALL.org_id%TYPE; --

347: g_po_release_id number := null;
348: g_document_type varchar2(25) := null;
349: g_number_records_processed number;
350: g_purchasing_ou_id PO_HEADERS_ALL.org_id%TYPE; --
351: g_hdr_requesting_ou_id PO_HEADERS_ALL.org_id%TYPE; --
352: g_rate_for_req_fields NUMBER; --
353: g_line_requesting_ou_id PO_REQUISITION_LINES_ALL.org_id%TYPE; --
354:
355: /* Global variable to hold number of req lines

Line 1038: from po_headers_all --

1034: ELSE
1035: l_progress:= '140';
1036: select segment1
1037: into x_document_number
1038: from po_headers_all --
1039: where po_header_id=x_document_id;
1040:
1041: END IF;
1042: /* CONSIGNED FPI end */

Line 1083: from po_headers_all

1079: -- Need to populate document number for autocreate success message
1080: IF g_document_subtype = 'STANDARD' THEN
1081: select segment1
1082: into x_document_number
1083: from po_headers_all
1084: where po_header_id = x_document_id;
1085: END IF;
1086: --
1087: else

Line 1112: update po_headers_all

1108:
1109: IF g_document_subtype = 'STANDARD' THEN
1110:
1111: l_progress:= '160';
1112: update po_headers_all
1113: set authorization_status = 'APPROVED',
1114: approved_date = sysdate,
1115: approved_flag = 'Y'
1116: where po_header_id = x_document_id;

Line 1262: l_document_creation_method po_headers_all.document_creation_method%type := p_document_creation_method; --

1258: l_contracts_call_exception Exception;
1259: --For using %type, dependence on OKC tables. Consider for refactor
1260: l_contract_doc_type VARCHAR2(150);
1261: --
1262: l_document_creation_method po_headers_all.document_creation_method%type := p_document_creation_method; --
1263: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
1264:
1265: l_terms_id PO_HEADERS.terms_id%TYPE;
1266: l_fob_lookup_code PO_HEADERS.fob_lookup_code%TYPE;

Line 1268: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

1264:
1265: l_terms_id PO_HEADERS.terms_id%TYPE;
1266: l_fob_lookup_code PO_HEADERS.fob_lookup_code%TYPE;
1267: l_freight_lookup_code PO_HEADERS.freight_terms_lookup_code%TYPE;
1268: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
1269: l_vs_terms_id PO_HEADERS.terms_id%TYPE;
1270: l_vs_fob_lookup_code PO_HEADERS.fob_lookup_code%TYPE;
1271: l_vs_freight_lookup_code PO_HEADERS.freight_terms_lookup_code%TYPE;
1272: l_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

Line 1272: l_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

1268: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
1269: l_vs_terms_id PO_HEADERS.terms_id%TYPE;
1270: l_vs_fob_lookup_code PO_HEADERS.fob_lookup_code%TYPE;
1271: l_vs_freight_lookup_code PO_HEADERS.freight_terms_lookup_code%TYPE;
1272: l_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
1273:
1274: l_is_complex_work_po BOOLEAN := FALSE; --
1275: l_style_id NUMBER; --
1276: tax_document_id NUMBER;

Line 1612: UPDATE po_headers_all --

1608: p_message => 'Update PO_Headers Doc subtype is Std or planned');
1609: END IF;
1610: --Bug 2295672 jbalakri : added 'REJECTED' case in decode statement.
1611:
1612: UPDATE po_headers_all --
1613: SET approved_flag =
1614: decode(nvl(approved_flag,'N'),'N','N','F','F','R'),
1615: authorization_status =
1616: decode(nvl(authorization_status,'INCOMPLETE'),

Line 1650: UPDATE po_headers_all --

1646: p_token => l_progress,
1647: p_message => 'Update PO_Headers Doc subtype is Release');
1648: END IF;
1649:
1650: UPDATE po_headers_all --
1651: SET closed_code = 'OPEN',
1652: closed_date = NULL,
1653: last_update_date = interface.last_update_date,
1654: last_updated_by = interface.last_updated_by ,

Line 1860: INSERT INTO po_headers_all --

1856: p_token => l_progress,
1857: p_message => 'Before Insert into PO_headers');
1858: END IF;
1859:
1860: INSERT INTO po_headers_all --
1861: (po_header_id,
1862: last_update_date,
1863: last_updated_by,
1864: segment1,

Line 2033: from po_headers_all

2029: IF nvl(interface.global_agreement_flag, 'N') = 'Y' then
2030: l_progress:= '240';
2031: select org_id
2032: into x_org_id
2033: from po_headers_all
2034: where po_header_id = interface.po_header_id;
2035:
2036: --
2037: --Replaced the INSERT statement with call to Row Handler.

Line 2348: UPDATE po_headers_all --

2344: END IF;
2345:
2346: l_progress := '325';
2347:
2348: UPDATE po_headers_all --
2349: set segment1=x_document_num
2350: where po_header_id=x_document_id;
2351:
2352: END IF;

Line 2781: l_type_lookup_code po_headers_all.type_lookup_code%type; --

2777: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
2779: --
2780: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
2781: l_type_lookup_code po_headers_all.type_lookup_code%type; --
2782: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
2783:
2784: -- oneoff 3201308 start
2785: l_needby_prf varchar2(1);

Line 2782: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --

2778: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
2779: --
2780: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
2781: l_type_lookup_code po_headers_all.type_lookup_code%type; --
2782: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
2783:
2784: -- oneoff 3201308 start
2785: l_needby_prf varchar2(1);
2786: l_shipto_prf varchar2(1);

Line 3125: FROM po_lines_all pol,po_headers_all poh

3121: --bug#3612701 modified the sql to fetch type lookup code
3122: --of the source document as well.
3123: SELECT pol.unit_meas_lookup_code,poh.type_lookup_code
3124: INTO l_ga_uom,l_from_type_lookup_code
3125: FROM po_lines_all pol,po_headers_all poh
3126: WHERE pol.po_line_id = interface.from_line_id
3127: and poh.po_header_id=interface.from_header_id
3128: and poh.po_header_id=pol.po_header_id;
3129: --bug#3612701

Line 3850: FROM po_headers_all

3846: l_negotiated_by_preparer_flag := 'Y';
3847: ELSIF interface.from_header_id is not null THEN
3848: l_progress := '390';
3849: SELECT type_lookup_code,global_agreement_flag into l_type_lookup_code,l_global_agreement_flag
3850: FROM po_headers_all
3851: WHERE po_header_id=interface.from_header_id;
3852: -- if the source document is global agreement.
3853: IF l_type_lookup_code='BLANKET' and l_global_agreement_flag='Y' THEN
3854: l_progress := '395';

Line 5292: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;

5288: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
5289: l_manual_price_change_flag po_line_locations_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
5290:
5291: -- Bug 5208159
5292: l_from_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5293:
5294: --
5295: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5296: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

Line 5351: FROM po_headers_all poh

5347: BEGIN
5348:
5349: SELECT poh.type_lookup_code
5350: INTO l_from_type_lookup_code
5351: FROM po_headers_all poh
5352: WHERE poh.po_header_id=interface.from_header_id ;
5353:
5354: IF g_debug_stmt THEN
5355: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 5399: po_headers_all poh --

5395: l_progress := '020';
5396: select unit_meas_lookup_code
5397: into x_po_uom
5398: from po_lines_all pol , --
5399: po_headers_all poh --
5400: where pol.po_header_id = poh.po_header_id
5401: and pol.po_header_id = interface.po_header_id
5402: and pol.line_num = interface.line_num;
5403: -- Bug 2735840 START

Line 6505: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;

6501: -- Bug 7661419 end
6502: --
6503: --
6504: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
6505: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;
6506: --
6507: --
6508:
6509: /* Bug 1030123: cursor to get all the distributions based on the line id */

Line 6531: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;

6527:
6528: l_amount_ordered NUMBER; --!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
6529: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --bug#3603067
6530: -- bug 5208159
6531: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;
6532:
6533: --introduced to hold the value of drop_ship_flag for shipments
6534: BEGIN
6535: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 6703: FROM po_headers_all poh

6699: BEGIN
6700:
6701: SELECT poh.type_lookup_code
6702: INTO l_from_type_lookup_code
6703: FROM po_headers_all poh
6704: WHERE poh.po_header_id=interface.from_header_id ;
6705:
6706: EXCEPTION
6707: WHEN OTHERS THEN

Line 6733: po_headers_all poh --

6729: l_progress := '090';
6730: select unit_meas_lookup_code
6731: into x_po_uom
6732: from po_lines_all pol , --
6733: po_headers_all poh --
6734: where pol.po_header_id = poh.po_header_id
6735: and pol.po_header_id = interface.po_header_id
6736: and pol.line_num = interface.line_num;
6737: -- Bug 2735840 START

Line 7462: UPDATE po_headers_all --

7458:
7459: IF (g_mode = 'ADD') THEN
7460:
7461: l_progress := '040';
7462: UPDATE po_headers_all --
7463: SET last_update_date = interface.last_update_date,
7464: last_updated_by = interface.last_updated_by,
7465: last_update_login = interface.last_update_login,
7466: status_lookup_code = 'I'

Line 7485: INSERT INTO po_headers_all --

7481: * But since the data type of interface.h_rate_date is already date,
7482: * this is unneccssary and causing problem when system date mask is
7483: * defined otherwise.
7484: */
7485: INSERT INTO po_headers_all --
7486: (po_header_id,
7487: last_update_date,
7488: last_updated_by,
7489: segment1,

Line 7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;

7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
7903:
7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
7906: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;

Line 8761: FROM po_headers_all ph --

8757: l_progress:='030';
8758: UPDATE po_headers_interface phi
8759: SET po_header_id =
8760: (SELECT ph.po_header_id
8761: FROM po_headers_all ph --
8762: WHERE 'RFQ' = ph.type_lookup_code
8763: AND phi.document_num = ph.segment1
8764: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99)) --
8765: WHERE interface_header_id = x_interface_header_id;

Line 8772: FROM po_headers_all ph --

8768: l_progress:='040';
8769: UPDATE po_headers_interface phi
8770: SET po_header_id =
8771: (SELECT ph.po_header_id
8772: FROM po_headers_all ph --
8773: WHERE decode(phi.document_subtype,
8774: 'RELEASE','BLANKET',
8775: phi.document_subtype) = ph.type_lookup_code
8776: AND phi.document_num = ph.segment1

Line 8810: FROM po_headers_all ph --

8806: rate,
8807: rate_type,
8808: rate_date,
8809: currency_code
8810: FROM po_headers_all ph --
8811: WHERE ph.po_header_id = phi.po_header_id)
8812: WHERE interface_header_id = x_interface_header_id;
8813:
8814: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 8935: FROM po_headers_all ph, --

8931: ph.shipping_control --
8932: INTO x_po_header_id,
8933: x_pay_on_code,
8934: l_shipping_control --
8935: FROM po_headers_all ph, --
8936: po_headers_interface phi
8937: WHERE phi.interface_header_id = x_interface_header_id
8938: AND ph.segment1 = phi.document_num
8939: AND ph.type_lookup_code='BLANKET'

Line 10332: FROM po_headers_all ph,

10328: END IF;
10329:
10330: SELECT NVL(max(pl.line_num),0)
10331: INTO x_line_num
10332: FROM po_headers_all ph,
10333: po_lines_all pl
10334: WHERE pl.po_header_id = ph.po_header_id
10335: AND ph.segment1 = x_document_num
10336: AND ph.type_lookup_code =

Line 10524: FROM po_headers_all ph,

10520: END IF;
10521:
10522: SELECT nvl(max(poll.shipment_num),0)
10523: INTO x_shipment_num
10524: FROM po_headers_all ph,
10525: po_line_locations_all poll,
10526: po_releases_all pr
10527: WHERE ph.po_header_id = poll.po_header_id
10528: AND ph.segment1 = x_document_num

Line 10741: po_headers_all poh

10737: pol.line_num
10738: INTO x_po_line_id,
10739: x_po_line_num
10740: FROM po_lines_all pol,
10741: po_headers_all poh
10742: WHERE poh.segment1 = x_document_num
10743: AND pol.line_num = x_interface_line_num
10744: AND poh.type_lookup_code =
10745: DECODE(g_document_type, 'RFQ', g_document_type,x_document_subtype)

Line 10873: , po_headers_all POH

10869: , po_line_id
10870: INTO x_po_line_num
10871: , x_po_line_id
10872: FROM po_lines_all POL2
10873: , po_headers_all POH
10874: , po_line_types_b PLT --
10875: WHERE POH.segment1 = x_document_num
10876: AND POH.po_header_id = POL2.po_header_id
10877: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 10987: po_headers_all POH

10983: po_line_id
10984: INTO x_po_line_num,
10985: x_po_line_id
10986: FROM po_lines_all POL2,
10987: po_headers_all POH
10988: WHERE POH.segment1 = x_document_num
10989: AND POH.po_header_id = POL2.po_header_id
10990: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99) --
10991: AND POH.type_lookup_code = 'RFQ'

Line 11356: FROM po_headers_all ph,

11352: END IF;
11353:
11354: SELECT NVL(max(pl.line_num), 0)
11355: INTO x_line_num
11356: FROM po_headers_all ph,
11357: po_lines_all pl
11358: WHERE pl.po_header_id = ph.po_header_id
11359: AND ph.segment1 = x_document_num
11360: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99)

Line 11589: po_headers_all poh,

11585:
11586: SELECT pol.po_line_id
11587: INTO x_po_line_id
11588: FROM po_lines_all pol,
11589: po_headers_all poh,
11590: po_lines_interface pli
11591: WHERE pol.po_header_id = poh.po_header_id
11592: AND poh.segment1 = x_document_num
11593: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99)

Line 12799: from po_headers_all ph, --

12795:
12796: l_progress := '030';
12797: select nvl(max(line_num),0)
12798: into x_line_num
12799: from po_headers_all ph, --
12800: po_lines_all pl --
12801: where pl.po_header_id = ph.po_header_id
12802: and ph.segment1 = x_document_num
12803: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99); --

Line 12860: from po_headers_all ph, --

12856: l_progress := '080';
12857:
12858: select nvl(max(shipment_num),0)
12859: into x_shipment_num
12860: from po_headers_all ph, --
12861: po_line_locations_all poll, --
12862: po_releases_all pr --
12863: where ph.po_header_id = poll.po_header_id
12864: and ph.segment1 = x_document_num