DBA Data[Home] [Help]

APPS.POR_CHANGE_REQUEST_PKG dependencies on PO_RCOTOLERANCE_PVT

Line 1041: SELECT nvl(po_rcotolerance_pvt.get_new_line_quantity(prl.requisition_header_id, prl.requisition_line_id, grp_id), 0)

1037: pcr.document_header_id = prl.requisition_header_id
1038: AND prl.requisition_line_id = reqlineid
1039: AND pcr.request_status = 'SYSTEMSAVE';
1040:
1041: SELECT nvl(po_rcotolerance_pvt.get_new_line_quantity(prl.requisition_header_id, prl.requisition_line_id, grp_id), 0)
1042: INTO changed_quantity
1043: FROM po_requisition_lines_all prl
1044: WHERE prl.requisition_line_id = reqlineid ;
1045: