DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER_COMMON dependencies on PO_VENDORS

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

1590: n IN BINARY_INTEGER
1591: ) IS
1592: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1593: x_progress VARCHAR2(3);
1594: x_vendor_id po_vendors.vendor_id%TYPE := NULL;
1595: x_error_status VARCHAR2(1);
1596: x_allow_sub_flag VARCHAR2(1);
1597: BEGIN
1598: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 1673: FROM po_vendors

1669: END IF;
1670:
1671: SELECT NVL(MAX(vendor_id), 0)
1672: INTO x_vendor_id
1673: FROM po_vendors
1674: WHERE vendor_id = x_cascaded_table(n).vendor_id
1675: AND allow_substitute_receipts_flag = 'Y';
1676:
1677: IF (x_vendor_id = 0) THEN