APPS.RCV_ROI_HEADER_COMMON dependencies on PO_LINES

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

1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1442: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1443: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1445: x_item_id_po po_lines.item_id%TYPE := NULL;
1446: x_error_status VARCHAR2(1);
1447: BEGIN
1448: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);
1449: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 1540: FROM po_lines

1536: -- do these checks only for PO based transactions
1537: IF x_cascaded_table(n).receipt_source_code = 'VENDOR' THEN --{
1538: SELECT NVL(MAX(item_id), -9999)
1539: INTO x_item_id_po
1540: FROM po_lines
1541: WHERE po_line_id = x_cascaded_table(n).po_line_id
1542: AND item_id = x_cascaded_table(n).item_id;
1543:
1544: IF (x_item_id_po = -9999) THEN

Line 1551: FROM po_lines

1547: END IF;
1548:
1549: SELECT NVL(MAX(item_id), -9999)
1550: INTO x_item_id_po
1551: FROM po_lines
1552: WHERE po_line_id = x_cascaded_table(n).po_line_id
1553: AND item_id = x_cascaded_table(n).item_id;
1554:
1555: IF (x_item_id_po <> x_cascaded_table(n).item_id) THEN

Line 1633: FROM po_lines

1629: INTO x_allow_sub_flag
1630: FROM (SELECT allow_substitute_receipts_flag
1631: FROM mtl_system_items
1632: WHERE inventory_item_id = (SELECT item_id
1633: FROM po_lines
1634: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1635: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1636: UNION ALL
1637: SELECT allow_substitute_receipts_flag

Line 1647: po_lines_all pl

1643: SELECT NVL(MIN(allow_substitute_receipts_flag),'N')
1644: INTO x_allow_sub_flag
1645: FROM (SELECT msi.allow_substitute_receipts_flag
1646: FROM mtl_system_items msi,
1647: po_lines_all pl
1648: WHERE msi.inventory_item_id = pl.item_id
1649: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1650: AND msi.organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1651: UNION ALL

Line 1693: FROM po_lines

1689: /* SELECT NVL(MAX(inventory_item_id), 0)
1690: INTO x_inventory_item
1691: FROM mtl_related_items
1692: WHERE inventory_item_id = (SELECT item_id
1693: FROM po_lines
1694: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1695: AND related_item_id = x_cascaded_table(n).substitute_item_id
1696: AND relationship_type_id = 2; -- substitute items
1697: -- and organization_id = nvl(x_cascaded_table(n).to_organization_id,organization_id)

Line 1705: po_lines_all pl

1701:
1702: SELECT NVL(MAX(inventory_item_id), 0)
1703: INTO x_inventory_item
1704: FROM mtl_related_items mri,
1705: po_lines_all pl
1706: WHERE mri.inventory_item_id = pl.item_id
1707: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1708: AND mri.related_item_id = x_cascaded_table(n).substitute_item_id
1709: AND mri.relationship_type_id = 2; -- substitute items

Line 1720: FROM po_lines

1716: /* SELECT NVL(MAX(inventory_item_id), 0)
1717: INTO x_inventory_item
1718: FROM mtl_related_items
1719: WHERE related_item_id = (SELECT item_id
1720: FROM po_lines
1721: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1722: AND inventory_item_id = x_cascaded_table(n).substitute_item_id
1723: AND reciprocal_flag = 'Y'
1724: AND relationship_type_id = 2;

Line 1732: po_lines_all pl

1728:
1729: SELECT NVL(MAX(inventory_item_id), 0)
1730: INTO x_inventory_item
1731: FROM mtl_related_items mri,
1732: po_lines_all pl
1733: WHERE mri.related_item_id = pl.item_id
1734: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1735: AND mri.inventory_item_id = x_cascaded_table(n).substitute_item_id
1736: AND mri.reciprocal_flag = 'Y'

Line 1776: x_item_revision po_lines.item_revision%TYPE;

1772: ) IS
1773: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1774: x_progress VARCHAR2(3);
1775: x_revision_control_flag VARCHAR2(1);
1776: x_item_revision po_lines.item_revision%TYPE;
1777: x_error_status VARCHAR2(1);
1778:
1779: /* Bug 5339860
1780: * Added support for substitute item revision validation