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 1637: po_vendors_sv.get_vendor_info

1633: vendor.freight_terms_lookup_code := null;
1634: vendor.terms_id := null;
1635: /*Bug 5715411 end */
1636:
1637: po_vendors_sv.get_vendor_info
1638: (interface.vendor_id,
1639: vendor.ship_to_location_id,
1640: vendor.bill_to_location_id,
1641: l_ship_via_lookup_code,

Line 1673: po_vendors_sv.val_freight_carrier(l_vs_ship_via_lookup_code,

1669: -- values from the vendor and validate them
1670:
1671: -- Validate ship via
1672: if l_vs_ship_via_lookup_code is not null then
1673: po_vendors_sv.val_freight_carrier(l_vs_ship_via_lookup_code,
1674: params.inventory_organization_id,
1675: vendor.ship_via_lookup_code);
1676: end if;
1677:

Line 1679: po_vendors_sv.val_freight_carrier(l_ship_via_lookup_code,

1675: vendor.ship_via_lookup_code);
1676: end if;
1677:
1678: if vendor.ship_via_lookup_code is null then
1679: po_vendors_sv.val_freight_carrier(l_ship_via_lookup_code,
1680: params.inventory_organization_id,
1681: vendor.ship_via_lookup_code);
1682: end if;
1683:

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

1682: end if;
1683:
1684: -- Validate fob code
1685: if l_vs_fob_lookup_code is not null then
1686: po_vendors_sv.val_fob(l_vs_fob_lookup_code,vendor.fob_lookup_code);
1687: end if;
1688:
1689: if vendor.fob_lookup_code is null then
1690: po_vendors_sv.val_fob(l_fob_lookup_code,vendor.fob_lookup_code);

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

1686: po_vendors_sv.val_fob(l_vs_fob_lookup_code,vendor.fob_lookup_code);
1687: end if;
1688:
1689: if vendor.fob_lookup_code is null then
1690: po_vendors_sv.val_fob(l_fob_lookup_code,vendor.fob_lookup_code);
1691: end if;
1692:
1693: -- Validate freight terms
1694: if l_vs_freight_lookup_code is not null then

Line 1695: po_vendors_sv.val_freight_terms(l_vs_freight_lookup_code,

1691: end if;
1692:
1693: -- Validate freight terms
1694: if l_vs_freight_lookup_code is not null then
1695: po_vendors_sv.val_freight_terms(l_vs_freight_lookup_code,
1696: vendor.freight_terms_lookup_code);
1697: end if;
1698:
1699: if vendor.freight_terms_lookup_code is null then

Line 1700: po_vendors_sv.val_freight_terms(l_freight_lookup_code,

1696: vendor.freight_terms_lookup_code);
1697: end if;
1698:
1699: if vendor.freight_terms_lookup_code is null then
1700: po_vendors_sv.val_freight_terms(l_freight_lookup_code,
1701: vendor.freight_terms_lookup_code);
1702: end if;
1703:
1704: -- Validate payment terms

Line 3715: from po_vendors vendor

3711: nvl(item.receipt_required_flag,
3712: vendor.RECEIPT_REQUIRED_FLAG)
3713: into item.inspection_required_flag,
3714: item.receipt_required_flag
3715: from po_vendors vendor
3716: where vendor.vendor_id = interface.vendor_id;
3717:
3718: Exception
3719: when no_data_found then

Line 4798: from po_vendors vendor

4794: nvl(item.receipt_required_flag,
4795: vendor.RECEIPT_REQUIRED_FLAG)
4796: into item.inspection_required_flag,
4797: item.receipt_required_flag
4798: from po_vendors vendor
4799: where vendor.vendor_id = interface.vendor_id;
4800:
4801: Exception
4802: when no_data_found then

Line 8407: FROM po_vendors

8403: if (X_vendor_id is not null) then
8404: l_progress := '020';
8405: SELECT match_option
8406: INTO x_invoice_match_option
8407: FROM po_vendors
8408: WHERE vendor_id = X_vendor_id;
8409: end if;
8410: end if;
8411:

Line 8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;

8514: --l_ship_to_organization_id NUMBER;
8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;

Line 12995: also added the outer join on po_vendors

12991: This part of the code gets the current Accrue on Receipt flag which will
12992: be compared with the other records in the interface table to see if
12993: they can be grouped together .
12994: Also added po_requisition_lines to the join to get the destination_type_code
12995: also added the outer join on po_vendors
12996: */
12997: /* Bug # 2224446, Autocreate was not grouping Req. lines when two req.
12998: with the same line details was entered. This happened when they don't
12999: Enter a Item in the lines block. We were not considering that the Item

Line 13026: po_vendors pov,

13022: po_headers_interface phi,
13023: po_requisition_lines_all prl, --
13024: mtl_system_items msi,
13025: po_line_types plt,
13026: po_vendors pov,
13027: po_system_parameters_all psp, --
13028: financials_system_params_all fsp --
13029: WHERE pli.item_id = msi.inventory_item_id(+)
13030: AND nvl(msi.organization_id,fsp.inventory_organization_id)=

Line 13091: PO_VENDORS POV,

13087: MTL_SYSTEM_ITEMS MSI ,
13088: PO_LINE_TYPES PLT ,
13089: PO_SYSTEM_PARAMETERS_ALL PSP , --
13090: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13091: PO_VENDORS POV,
13092: PO_HEADERS_INTERFACE PHI
13093: WHERE PLI.LINE_NUM = x_po_line_num
13094: AND PLI.shipment_num is not null
13095: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 13212: PO_VENDORS POV,

13208: MTL_SYSTEM_ITEMS MSI ,
13209: PO_LINE_TYPES PLT ,
13210: PO_SYSTEM_PARAMETERS_ALL PSP , --
13211: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13212: PO_VENDORS POV,
13213: PO_HEADERS_INTERFACE PHI
13214: WHERE PLI.LINE_NUM = x_po_line_num
13215: AND PLI.shipment_num is not null
13216: AND PLI.item_id = MSI.inventory_item_id

Line 13340: PO_VENDORS POV,

13336: MTL_SYSTEM_ITEMS MSI ,
13337: PO_LINE_TYPES PLT ,
13338: PO_SYSTEM_PARAMETERS_ALL PSP , --
13339: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --
13340: PO_VENDORS POV,
13341: PO_HEADERS_INTERFACE PHI
13342: WHERE PLI.LINE_NUM = x_po_line_num
13343: AND PLI.shipment_num is not null
13344: AND NVL(psp.org_id, -99) = NVL(g_purchasing_ou_id, -99) --