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_VENDORS

Line 43: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have

39: TYPE vendor_defaults_type IS RECORD
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,

Line 50: type_1099 po_vendors.type_1099%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,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,

Line 51: hold_flag po_vendors.hold_flag%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,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,
55: vat_registration_num po_vendors.vat_registration_num%type := null, --

Line 52: invoice_currency_code po_vendors.invoice_currency_code%type := 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,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,
55: vat_registration_num po_vendors.vat_registration_num%type := null, --
56: inspection_required_flag po_vendors.inspection_required_flag%type := null,

Line 53: receipt_required_flag po_vendors.receipt_required_flag%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,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,
55: vat_registration_num po_vendors.vat_registration_num%type := null, --
56: inspection_required_flag po_vendors.inspection_required_flag%type := null,
57: /** bgu, Dec. 7, 98

Line 54: num_1099 po_vendors.num_1099%type := 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,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,
55: vat_registration_num po_vendors.vat_registration_num%type := null, --
56: inspection_required_flag po_vendors.inspection_required_flag%type := null,
57: /** bgu, Dec. 7, 98
58: * Used to default invoice match flag from financial system parameter,

Line 55: vat_registration_num po_vendors.vat_registration_num%type := null, --

51: hold_flag po_vendors.hold_flag%type := null,
52: invoice_currency_code po_vendors.invoice_currency_code%type := null,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,
55: vat_registration_num po_vendors.vat_registration_num%type := null, --
56: inspection_required_flag po_vendors.inspection_required_flag%type := null,
57: /** bgu, Dec. 7, 98
58: * Used to default invoice match flag from financial system parameter,
59: * vendor and vendor site

Line 56: inspection_required_flag po_vendors.inspection_required_flag%type := null,

52: invoice_currency_code po_vendors.invoice_currency_code%type := null,
53: receipt_required_flag po_vendors.receipt_required_flag%type := null,
54: num_1099 po_vendors.num_1099%type := null,
55: vat_registration_num po_vendors.vat_registration_num%type := null, --
56: inspection_required_flag po_vendors.inspection_required_flag%type := null,
57: /** bgu, Dec. 7, 98
58: * Used to default invoice match flag from financial system parameter,
59: * vendor and vendor site
60: */

Line 61: invoice_match_option po_vendors.match_option%type := null,

57: /** bgu, Dec. 7, 98
58: * Used to default invoice match flag from financial system parameter,
59: * vendor and vendor site
60: */
61: invoice_match_option po_vendors.match_option%type := null,
62: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL --
63: );
64:
65: /* Type declaration for Item defaults structure */

Line 1423: po_vendors_sv.get_vendor_info

1419: vendor.freight_terms_lookup_code := null;
1420: vendor.terms_id := null;
1421: /*Bug 5715411 end */
1422:
1423: po_vendors_sv.get_vendor_info
1424: (interface.vendor_id,
1425: vendor.ship_to_location_id,
1426: vendor.bill_to_location_id,
1427: l_ship_via_lookup_code,

Line 1459: po_vendors_sv.val_freight_carrier(l_vs_ship_via_lookup_code,

1455: -- values from the vendor and validate them
1456:
1457: -- Validate ship via
1458: if l_vs_ship_via_lookup_code is not null then
1459: po_vendors_sv.val_freight_carrier(l_vs_ship_via_lookup_code,
1460: params.inventory_organization_id,
1461: vendor.ship_via_lookup_code);
1462: end if;
1463:

Line 1465: po_vendors_sv.val_freight_carrier(l_ship_via_lookup_code,

1461: vendor.ship_via_lookup_code);
1462: end if;
1463:
1464: if vendor.ship_via_lookup_code is null then
1465: po_vendors_sv.val_freight_carrier(l_ship_via_lookup_code,
1466: params.inventory_organization_id,
1467: vendor.ship_via_lookup_code);
1468: end if;
1469:

Line 1472: po_vendors_sv.val_fob(l_vs_fob_lookup_code,vendor.fob_lookup_code);

1468: end if;
1469:
1470: -- Validate fob code
1471: if l_vs_fob_lookup_code is not null then
1472: po_vendors_sv.val_fob(l_vs_fob_lookup_code,vendor.fob_lookup_code);
1473: end if;
1474:
1475: if vendor.fob_lookup_code is null then
1476: po_vendors_sv.val_fob(l_fob_lookup_code,vendor.fob_lookup_code);

Line 1476: po_vendors_sv.val_fob(l_fob_lookup_code,vendor.fob_lookup_code);

1472: po_vendors_sv.val_fob(l_vs_fob_lookup_code,vendor.fob_lookup_code);
1473: end if;
1474:
1475: if vendor.fob_lookup_code is null then
1476: po_vendors_sv.val_fob(l_fob_lookup_code,vendor.fob_lookup_code);
1477: end if;
1478:
1479: -- Validate freight terms
1480: if l_vs_freight_lookup_code is not null then

Line 1481: po_vendors_sv.val_freight_terms(l_vs_freight_lookup_code,

1477: end if;
1478:
1479: -- Validate freight terms
1480: if l_vs_freight_lookup_code is not null then
1481: po_vendors_sv.val_freight_terms(l_vs_freight_lookup_code,
1482: vendor.freight_terms_lookup_code);
1483: end if;
1484:
1485: if vendor.freight_terms_lookup_code is null then

Line 1486: po_vendors_sv.val_freight_terms(l_freight_lookup_code,

1482: vendor.freight_terms_lookup_code);
1483: end if;
1484:
1485: if vendor.freight_terms_lookup_code is null then
1486: po_vendors_sv.val_freight_terms(l_freight_lookup_code,
1487: vendor.freight_terms_lookup_code);
1488: end if;
1489:
1490: -- Validate payment terms

Line 3351: from po_vendors vendor

3347: nvl(item.receipt_required_flag,
3348: vendor.RECEIPT_REQUIRED_FLAG)
3349: into item.inspection_required_flag,
3350: item.receipt_required_flag
3351: from po_vendors vendor
3352: where vendor.vendor_id = interface.vendor_id;
3353:
3354: Exception
3355: when no_data_found then

Line 4371: from po_vendors vendor

4367: nvl(item.receipt_required_flag,
4368: vendor.RECEIPT_REQUIRED_FLAG)
4369: into item.inspection_required_flag,
4370: item.receipt_required_flag
4371: from po_vendors vendor
4372: where vendor.vendor_id = interface.vendor_id;
4373:
4374: Exception
4375: when no_data_found then

Line 7800: FROM po_vendors

7796: if (X_vendor_id is not null) then
7797: l_progress := '020';
7798: SELECT match_option
7799: INTO x_invoice_match_option
7800: FROM po_vendors
7801: WHERE vendor_id = X_vendor_id;
7802: end if;
7803: end if;
7804:

Line 7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;

7907: --l_ship_to_organization_id NUMBER;
7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;

Line 12273: also added the outer join on po_vendors

12269: This part of the code gets the current Accrue on Receipt flag which will
12270: be compared with the other records in the interface table to see if
12271: they can be grouped together .
12272: Also added po_requisition_lines to the join to get the destination_type_code
12273: also added the outer join on po_vendors
12274: */
12275: /* Bug # 2224446, Autocreate was not grouping Req. lines when two req.
12276: with the same line details was entered. This happened when they don't
12277: Enter a Item in the lines block. We were not considering that the Item

Line 12304: po_vendors pov,

12300: po_headers_interface phi,
12301: po_requisition_lines_all prl, --
12302: mtl_system_items msi,
12303: po_line_types plt,
12304: po_vendors pov,
12305: po_system_parameters_all psp, --
12306: financials_system_params_all fsp --
12307: WHERE pli.item_id = msi.inventory_item_id(+)
12308: AND nvl(msi.organization_id,fsp.inventory_organization_id)=

Line 12369: PO_VENDORS POV,

12365: MTL_SYSTEM_ITEMS MSI ,
12366: PO_LINE_TYPES PLT ,
12367: PO_SYSTEM_PARAMETERS_ALL PSP , --
12368: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12369: PO_VENDORS POV,
12370: PO_HEADERS_INTERFACE PHI
12371: WHERE PLI.LINE_NUM = x_po_line_num
12372: AND PLI.shipment_num is not null
12373: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 12490: PO_VENDORS POV,

12486: MTL_SYSTEM_ITEMS MSI ,
12487: PO_LINE_TYPES PLT ,
12488: PO_SYSTEM_PARAMETERS_ALL PSP , --
12489: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12490: PO_VENDORS POV,
12491: PO_HEADERS_INTERFACE PHI
12492: WHERE PLI.LINE_NUM = x_po_line_num
12493: AND PLI.shipment_num is not null
12494: AND PLI.item_id = MSI.inventory_item_id

Line 12618: PO_VENDORS POV,

12614: MTL_SYSTEM_ITEMS MSI ,
12615: PO_LINE_TYPES PLT ,
12616: PO_SYSTEM_PARAMETERS_ALL PSP , --
12617: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
12618: PO_VENDORS POV,
12619: PO_HEADERS_INTERFACE PHI
12620: WHERE PLI.LINE_NUM = x_po_line_num
12621: AND PLI.shipment_num is not null
12622: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --