APPS.RCV_ROI_HEADER_COMMON dependencies on PO_LINES

Line 1535: x_item_id_po po_lines.item_id%TYPE := NULL;

1531: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1532: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1533: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1534: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1535: x_item_id_po po_lines.item_id%TYPE := NULL;
1536: x_error_status VARCHAR2(1);
1537: BEGIN
1538: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);
1539: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 1632: FROM po_lines

1628: -- do these checks only for PO based transactions
1629: IF x_cascaded_table(n).receipt_source_code = 'VENDOR' THEN --{
1630: SELECT NVL(MAX(item_id), -9999)
1631: INTO x_item_id_po
1632: FROM po_lines
1633: WHERE po_line_id = x_cascaded_table(n).po_line_id
1634: AND item_id = x_cascaded_table(n).item_id;
1635:
1636: IF (x_item_id_po = -9999) THEN

Line 1643: FROM po_lines

1639: END IF;
1640:
1641: SELECT NVL(MAX(item_id), -9999)
1642: INTO x_item_id_po
1643: FROM po_lines
1644: WHERE po_line_id = x_cascaded_table(n).po_line_id
1645: AND item_id = x_cascaded_table(n).item_id;
1646:
1647: IF (x_item_id_po <> x_cascaded_table(n).item_id) THEN

Line 1725: FROM po_lines

1721: INTO x_allow_sub_flag
1722: FROM (SELECT allow_substitute_receipts_flag
1723: FROM mtl_system_items
1724: WHERE inventory_item_id = (SELECT item_id
1725: FROM po_lines
1726: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1727: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1728: UNION ALL
1729: SELECT allow_substitute_receipts_flag

Line 1782: FROM po_lines

1778: /* SELECT NVL(MAX(inventory_item_id), 0)
1779: INTO x_inventory_item
1780: FROM mtl_related_items
1781: WHERE inventory_item_id = (SELECT item_id
1782: FROM po_lines
1783: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1784: AND related_item_id = x_cascaded_table(n).substitute_item_id
1785: AND relationship_type_id = 2; -- substitute items
1786: -- and organization_id = nvl(x_cascaded_table(n).to_organization_id,organization_id)

Line 1794: po_lines_all pl

1790:
1791: SELECT NVL(MAX(inventory_item_id), 0)
1792: INTO x_inventory_item
1793: FROM mtl_related_items mri,
1794: po_lines_all pl
1795: WHERE mri.inventory_item_id = pl.item_id
1796: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1797: AND mri.related_item_id = x_cascaded_table(n).substitute_item_id
1798: AND mri.relationship_type_id = 2; -- substitute items

Line 1809: FROM po_lines

1805: /* SELECT NVL(MAX(inventory_item_id), 0)
1806: INTO x_inventory_item
1807: FROM mtl_related_items
1808: WHERE related_item_id = (SELECT item_id
1809: FROM po_lines
1810: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1811: AND inventory_item_id = x_cascaded_table(n).substitute_item_id
1812: AND reciprocal_flag = 'Y'
1813: AND relationship_type_id = 2;

Line 1821: po_lines_all pl

1817:
1818: SELECT NVL(MAX(inventory_item_id), 0)
1819: INTO x_inventory_item
1820: FROM mtl_related_items mri,
1821: po_lines_all pl
1822: WHERE mri.related_item_id = pl.item_id
1823: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1824: AND mri.inventory_item_id = x_cascaded_table(n).substitute_item_id
1825: AND mri.reciprocal_flag = 'Y'

Line 1865: x_item_revision po_lines.item_revision%TYPE;

1861: ) IS
1862: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1863: x_progress VARCHAR2(3);
1864: x_revision_control_flag VARCHAR2(1);
1865: x_item_revision po_lines.item_revision%TYPE;
1866: x_error_status VARCHAR2(1);
1867:
1868: /* Bug 5339860
1869: * Added support for substitute item revision validation