APPS.CSP_MINMAX_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 1354: -- po_requisitions_interface_all

1350: RETURN(l_total);
1351: END IF;
1352:
1353: --
1354: -- po_requisitions_interface_all
1355: --
1356: -- Bug: 2320752
1357: -- Do not include records in error status
1358: -- 2866966 added nvl to condition checking

Line 1362: FROM po_requisitions_interface_all

1358: -- 2866966 added nvl to condition checking
1359: -- for error process flag
1360: SELECT NVL(SUM(quantity),0)
1361: INTO l_qty
1362: FROM po_requisitions_interface_all
1363: WHERE destination_organization_id = p_org_id
1364: AND item_id = p_item_id
1365: AND p_include_po = 1
1366: AND (p_level = 1 or destination_subinventory = p_subinv)

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

1386: AND sub2.availability_type = decode(p_include_nonnet,
1387: 1,sub2.availability_type,1)) OR
1388: p_level = 2);
1389:
1390: print_debug('Supply from po_requisitions_interface_all: ' || to_char(l_qty)
1391: , 'get_supply_qty'
1392: , 9);
1393: l_total := l_total + NVL(l_qty,0);
1394:

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

2832: print_debug('Item rev: ' || l_item_revision, 're_po', 9);
2833: END IF ;
2834:
2835:
2836: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);
2837:
2838: INSERT INTO po_requisitions_interface_all(
2839: LAST_UPDATE_DATE,
2840: LAST_UPDATED_BY,

Line 2838: INSERT INTO po_requisitions_interface_all(

2834:
2835:
2836: print_debug('Inserting into PO_REQUISITIONS_INTERFACE_ALL', 're_po', 9);
2837:
2838: INSERT INTO po_requisitions_interface_all(
2839: LAST_UPDATE_DATE,
2840: LAST_UPDATED_BY,
2841: ITEM_DESCRIPTION,
2842: CREATION_DATE,