APPS.INV_MINMAX_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 1310: -- po_requisitions_interface_all

1306: RETURN(l_total);
1307: END IF;
1308:
1309: --
1310: -- po_requisitions_interface_all
1311: --
1312: -- Bug: 2320752
1313: -- Do not include records in error status
1314: -- kkoothan Bug Fix 2891818

Line 1320: of quantities in po_requisitions_interface_all if uom_code is different than

1316: -- so that the interface records with NULL value for process_flag
1317: -- are considered as Interface Supply.
1318: --
1319: /* Bug 3894347 -- Added the following section of code to consider conversion
1320: of quantities in po_requisitions_interface_all if uom_code is different than
1321: primary uom code */
1322:
1323: SELECT uom_code
1324: INTO l_puom

Line 1331: --in the po_requisitions_interface_all table.

1327: AND msiv.organization_id = p_org_id
1328: AND muom.unit_of_measure = msiv.primary_unit_of_measure;
1329:
1330: --Bug9122329, calling the function get_item_uom_code in case when uom_code is null
1331: --in the po_requisitions_interface_all table.
1332:
1333: SELECT NVL(SUM(DECODE(NVL(uom_code,get_item_uom_code(unit_of_measure)),
1334: l_puom,quantity,
1335: INV_CONVERT.INV_UM_CONVERT(p_item_id,null,quantity,NVL(uom_code,get_item_uom_code(unit_of_measure)),l_puom,null,null)

Line 1338: FROM po_requisitions_interface_all

1334: l_puom,quantity,
1335: INV_CONVERT.INV_UM_CONVERT(p_item_id,null,quantity,NVL(uom_code,get_item_uom_code(unit_of_measure)),l_puom,null,null)
1336: )),0)
1337: INTO l_qty
1338: FROM po_requisitions_interface_all
1339: WHERE destination_organization_id = p_org_id
1340: AND item_id = p_item_id
1341: AND p_include_po = 1
1342: AND (p_level = 1 or destination_subinventory = p_subinv)

Line 1367: print_debug('Supply from po_requisitions_interface_all: ' || to_char(l_qty)

1363: 1,sub2.availability_type,1)) OR
1364: p_level = 2);
1365:
1366: IF G_TRACE_ON = 1 THEN
1367: print_debug('Supply from po_requisitions_interface_all: ' || to_char(l_qty)
1368: , 'get_supply_qty'
1369: , 9);
1370: END IF;
1371: l_total := l_total + NVL(l_qty,0);

Line 4031: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);

4027: END IF;
4028: /* End of Changes for Bug 3894347 */
4029:
4030: IF G_TRACE_ON = 1 THEN
4031: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);
4032: END IF;
4033:
4034: INSERT INTO po_requisitions_interface_all(
4035: LAST_UPDATE_DATE,

Line 4034: INSERT INTO po_requisitions_interface_all(

4030: IF G_TRACE_ON = 1 THEN
4031: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);
4032: END IF;
4033:
4034: INSERT INTO po_requisitions_interface_all(
4035: LAST_UPDATE_DATE,
4036: LAST_UPDATED_BY,
4037: ITEM_DESCRIPTION,
4038: CREATION_DATE,

Line 4582: -- MUOM table based on unit_of_measure info from the po_requisitions_interface_all.

4578: RAISE;
4579: END get_loaded_qty;
4580:
4581: -- Bug9122329, get_item_uom_code function added to fetch the uom_code from
4582: -- MUOM table based on unit_of_measure info from the po_requisitions_interface_all.
4583:
4584: FUNCTION get_item_uom_code (p_uom_name VARCHAR2) RETURN VARCHAR2 IS
4585:
4586: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%type := NULL;