APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_SYSTEM_ITEMS_B

Line 1752: FROM mtl_system_items_b

1748:
1749: -------Checking if the item is dual UOM controlled. If not then Return .
1750: SELECT tracking_quantity_ind , secondary_default_ind
1751: INTO l_TRACKING_QUANTITY_IND ,l_secondary_default_ind
1752: FROM mtl_system_items_b
1753: WHERE INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1754: AND ORGANIZATION_ID = x_att_rec.to_organization_id;
1755:
1756: l_progress :='0004';

Line 1839: FROM MTL_SYSTEM_ITEMS_B

1835: BEGIN
1836:
1837: SELECT SECONDARY_UOM_CODE
1838: INTO l_secondary_uom_code
1839: FROM MTL_SYSTEM_ITEMS_B
1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
1842:
1843: IF g_asn_debug = 'Y' THEN

Line 1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id

1836:
1837: SELECT SECONDARY_UOM_CODE
1838: INTO l_secondary_uom_code
1839: FROM MTL_SYSTEM_ITEMS_B
1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
1842:
1843: IF g_asn_debug = 'Y' THEN
1844: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );

Line 1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;

1837: SELECT SECONDARY_UOM_CODE
1838: INTO l_secondary_uom_code
1839: FROM MTL_SYSTEM_ITEMS_B
1840: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1841: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
1842:
1843: IF g_asn_debug = 'Y' THEN
1844: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
1845: END IF;

Line 1896: FROM MTL_SYSTEM_ITEMS_B

1892: BEGIN
1893:
1894: SELECT SECONDARY_UOM_CODE
1895: INTO x_att_rec.secondary_uom_code
1896: FROM MTL_SYSTEM_ITEMS_B
1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1899:
1900: IF g_asn_debug = 'Y' THEN

Line 1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id

1893:
1894: SELECT SECONDARY_UOM_CODE
1895: INTO x_att_rec.secondary_uom_code
1896: FROM MTL_SYSTEM_ITEMS_B
1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1899:
1900: IF g_asn_debug = 'Y' THEN
1901: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);

Line 1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;

1894: SELECT SECONDARY_UOM_CODE
1895: INTO x_att_rec.secondary_uom_code
1896: FROM MTL_SYSTEM_ITEMS_B
1897: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1898: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1899:
1900: IF g_asn_debug = 'Y' THEN
1901: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);
1902: END IF;

Line 1954: FROM MTL_SYSTEM_ITEMS_B

1950: BEGIN
1951:
1952: SELECT SECONDARY_UOM_CODE
1953: INTO x_att_rec.secondary_uom_code
1954: FROM MTL_SYSTEM_ITEMS_B
1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1957:
1958: IF g_asn_debug = 'Y' THEN

Line 1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id

1951:
1952: SELECT SECONDARY_UOM_CODE
1953: INTO x_att_rec.secondary_uom_code
1954: FROM MTL_SYSTEM_ITEMS_B
1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1957:
1958: IF g_asn_debug = 'Y' THEN
1959: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );

Line 1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;

1952: SELECT SECONDARY_UOM_CODE
1953: INTO x_att_rec.secondary_uom_code
1954: FROM MTL_SYSTEM_ITEMS_B
1955: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1956: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1957:
1958: IF g_asn_debug = 'Y' THEN
1959: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );
1960: END IF;

Line 1992: FROM MTL_SYSTEM_ITEMS_B

1988: BEGIN
1989:
1990: SELECT SECONDARY_UOM_CODE
1991: INTO l_secondary_uom_code
1992: FROM MTL_SYSTEM_ITEMS_B
1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1995:
1996: IF g_asn_debug = 'Y' THEN

Line 1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id

1989:
1990: SELECT SECONDARY_UOM_CODE
1991: INTO l_secondary_uom_code
1992: FROM MTL_SYSTEM_ITEMS_B
1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1995:
1996: IF g_asn_debug = 'Y' THEN
1997: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );

Line 1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;

1990: SELECT SECONDARY_UOM_CODE
1991: INTO l_secondary_uom_code
1992: FROM MTL_SYSTEM_ITEMS_B
1993: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
1994: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
1995:
1996: IF g_asn_debug = 'Y' THEN
1997: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
1998: END IF;