APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_ITM_DTLS

Line 340: FROM JAI_PO_OSP_ITM_DTLS dtl

336: AND wip_supply_type <> 6;
337:
338: CURSOR c_check_ja_osp(cp_item_id NUMBER) IS
339: SELECT COUNT(1)
340: FROM JAI_PO_OSP_ITM_DTLS dtl
341: WHERE osp_item_id = cp_item_id;
342:
343: ln_check_57f4_exists number;
344: ln_form_id number;

Line 609: from JAI_PO_OSP_ITM_DTLS dtl

605: where ( ln_routing_ctr > 0 OR ln_reqmt_op_ctr + ln_ja_ctr = 0) /*Bug 4609260*/
606: /*above condition changed for bug 8602495*/
607: union
608: select 1 , dtl.quantity , dtl.item_id , 1 , 'M' item_type,'Manual Entry' comments
609: from JAI_PO_OSP_ITM_DTLS dtl
610: where osp_item_id = rec_po_line_cur.item_id
611: ) /*
612: The wip_supply_type != 6 indicates that phantom kit itself should not come in the 57F4 challan instead the
613: components should feature in the 57F4. Supply Type = 6 indicates a phantom supply type.