APPS.JAI_PO_OSP_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 132: from po_distributions_all

128: jai_cmn_utils_pkg.print_log('b13541366.log','1 Inside ja_in_57F4_process_header begin ');
129:
130: For c_Line_rec in
131: (Select distinct po_line_id
132: from po_distributions_all
133: where po_header_id = p_po_header_id
134: and
135: ( ( p_called_from = lv_called_release and po_release_id = p_po_release_id) --'RELEASE' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
136: OR

Line 331: CURSOR c_check_reqmt_ops( cp_wip_entity_id po_distributions_all.wip_entity_id%TYPE , cp_wip_op_seq_num po_distributions_all.wip_operation_seq_num%TYPE) IS

327: FROM wip_operations
328: WHERE wip_entity_id = cp_wip_entity_id
329: AND operation_seq_num < cp_wip_operation ;
330:
331: CURSOR c_check_reqmt_ops( cp_wip_entity_id po_distributions_all.wip_entity_id%TYPE , cp_wip_op_seq_num po_distributions_all.wip_operation_seq_num%TYPE) IS
332: SELECT count(1)
333: FROM wip_requirement_operations
334: WHERE wip_entity_id = cp_wip_entity_id
335: AND operation_seq_num = cp_wip_op_seq_num

Line 440: FROM po_distributions_all

436: destination_organization_id orgn_id ,
437: deliver_to_location_id loc_id ,
438: wip_entity_id, wip_operation_seq_num,
439: wip_repetitive_schedule_id, wip_line_id
440: FROM po_distributions_all
441: WHERE po_header_id = p_po_header_id
442: and po_line_id = rec_po_line_cur.po_line_id
443: and
444: ( ( p_called_from = 'RELEASE' and po_release_id = p_po_release_id)

Line 895: FROM po_distributions_all

891:
892: CURSOR c_po_dist_info IS
893: SELECT po_distribution_id, wip_entity_id, wip_line_id,
894: wip_repetitive_schedule_id, wip_operation_seq_num
895: FROM po_distributions_all
896: WHERE line_location_id = r_base_trx.po_line_location_id
897: AND ROWNUM = 1;
898:
899: CURSOR c_assembly_id(cp_wip_entity NUMBER) IS

Line 1311: FROM po_distributions_all

1307:
1308: --**********FETCHING VALUES FROM RCV_TRANSACTIONS**********
1309: CURSOR c_get_rcv_trans IS
1310: SELECT wip_entity_id
1311: FROM po_distributions_all
1312: WHERE line_location_id = p_po_line_location_id
1313: AND rownum = 1;
1314:
1315: -- 2746952

Line 1371: from po_distributions_all

1367:
1368: -- sriram - bug # 3021456
1369: cursor c_po_qty_cur(p_po_hdr_id number , p_po_line_id number) is
1370: select quantity_ordered
1371: from po_distributions_all
1372: where po_header_id = p_po_hdr_id
1373: and po_line_id = p_po_line_id;
1374:
1375: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea