APPS.PO_OM_INTEGRATION_GRP dependencies on PO_REQUISITION_LINES_ALL

Line 146: l_request_unit_of_measure PO_REQUISITION_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;

142: l_count NUMBER;
143:
144: -- Bug# 8970502 : Added the following variables
145:
146: l_request_unit_of_measure PO_REQUISITION_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
147: l_request_secondary_uom PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
148:
149: --Bug# 4640038 Start, Added the following variable
150:

Line 147: l_request_secondary_uom PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;

143:
144: -- Bug# 8970502 : Added the following variables
145:
146: l_request_unit_of_measure PO_REQUISITION_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
147: l_request_secondary_uom PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
148:
149: --Bug# 4640038 Start, Added the following variable
150:
151: l_po_request_unit_of_measure PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;

Line 367: FROM po_requisition_lines_all

363:
364:
365: SELECT unit_meas_lookup_code, secondary_unit_of_measure
366: INTO l_request_unit_of_measure, l_request_secondary_uom
367: FROM po_requisition_lines_all
368: WHERE requisition_line_id = p_req_line_id(i);
369:
370: */
371:

Line 500: FROM po_requisition_lines_all

496: -- Bug 3639067 START
497: -- Only synchronize if the line is flagged as drop ship.
498: SELECT drop_ship_flag
499: INTO l_drop_ship_flag
500: FROM po_requisition_lines_all
501: WHERE requisition_line_id = p_req_line_id(i);
502:
503: IF (l_drop_ship_flag = 'Y') THEN
504: -- Bug 3639067 END

Line 552: from po_requisition_lines_all

548: secondary_unit_of_measure
549: INTO l_item_id,
550: l_request_unit_of_measure,
551: l_request_secondary_uom
552: from po_requisition_lines_all
553: WHERE requisition_line_id = p_req_line_id(i);
554:
555: IF (g_debug_stmt) THEN
556: PO_DEBUG.debug_stmt (

Line 609: FROM po_requisition_lines_all

605: ELSE
606: SELECT round((p_quantity(i) * l_uom_conversion_rate),5) + nvl(sum(nvl(
607: quantity_delivered, 0)), 0)
608: INTO l_quantity_ordered(i)
609: FROM po_requisition_lines_all
610: WHERE requisition_line_id = p_req_line_id(i);
611: END IF;
612:
613: -- Bug#8970502 Added the conversion rate calculation below

Line 620: FROM po_requisition_lines_all

616: ELSE
617: SELECT round((p_secondary_quantity(i) * l_suom_conversion_rate),5) + NVL(SUM(NVL(
618: secondary_quantity_received,0)),0)
619: INTO l_secondary_quantity_ordered(i)
620: FROM po_requisition_lines_all
621: WHERE requisition_line_id = p_req_line_id(i);
622: END IF;
623:
624: -- Bug8970502 End

Line 973: FROM po_requisition_lines_all PRL

969: FORALL i IN 1..p_req_line_id.COUNT
970: INSERT INTO po_session_gt
971: (key, num1, num2)
972: SELECT l_session_gt_key, PRL.requisition_line_id, PRL.requisition_header_id
973: FROM po_requisition_lines_all PRL
974: WHERE PRL.requisition_line_id = p_req_line_id(i)
975: AND PRL.drop_ship_flag = 'Y';
976:
977: -- SQL What: Select the req line and header IDs from PO_SESSION_GT into