DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER_COMMON dependencies on PO_VENDORS

Line 1686: x_vendor_id po_vendors.vendor_id%TYPE := NULL;

1682: n IN BINARY_INTEGER
1683: ) IS
1684: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1685: x_progress VARCHAR2(3);
1686: x_vendor_id po_vendors.vendor_id%TYPE := NULL;
1687: x_error_status VARCHAR2(1);
1688: x_allow_sub_flag VARCHAR2(1);
1689: BEGIN
1690: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 1762: FROM po_vendors

1758: -- Bug 13926508: Commenting Supplier level validation since it is not required for substitute item receipts.
1759:
1760: /* SELECT NVL(MAX(vendor_id), 0)
1761: INTO x_vendor_id
1762: FROM po_vendors
1763: WHERE vendor_id = x_cascaded_table(n).vendor_id
1764: AND allow_substitute_receipts_flag = 'Y';
1765:
1766: IF (x_vendor_id = 0) THEN