APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_OPM_OSP_DTLS

Line 26: FROM JAI_OPM_OSP_DTLS

22: AND a.SHIP_TO_LOCATION_ID = b.LOCATION_ID;
23:
24: Cursor C_Osp_Rcpt_Dtl IS
25: SELECT organization_id, INVENTORY_ITEM_ID,act_quantity,uom_code
26: FROM JAI_OPM_OSP_DTLS
27: WHERE osp_header_id = pr_new.batch_id
28: and issue_recpt_flag = 'R';
29:
30: Cursor C_Tot_Excise IS SELECT SUM(excise_payable) tot_excise_payable

Line 31: FROM JAI_OPM_OSP_DTLS

27: WHERE osp_header_id = pr_new.batch_id
28: and issue_recpt_flag = 'R';
29:
30: Cursor C_Tot_Excise IS SELECT SUM(excise_payable) tot_excise_payable
31: FROM JAI_OPM_OSP_DTLS
32: WHERE osp_header_id = pr_new.batch_id and
33: issue_recpt_flag = 'I';
34:
35: Cursor C_Act_Out_Qty IS SELECT SUM(act_quantity) tot_qty

Line 36: FROM JAI_OPM_OSP_DTLS

32: WHERE osp_header_id = pr_new.batch_id and
33: issue_recpt_flag = 'I';
34:
35: Cursor C_Act_Out_Qty IS SELECT SUM(act_quantity) tot_qty
36: FROM JAI_OPM_OSP_DTLS
37: WHERE osp_header_id = pr_new.batch_id and
38: issue_recpt_flag = 'R';
39:
40: Cursor C_Plan_Out_Qty IS SELECT plan_quantity plan_qty

Line 41: FROM JAI_OPM_OSP_DTLS

37: WHERE osp_header_id = pr_new.batch_id and
38: issue_recpt_flag = 'R';
39:
40: Cursor C_Plan_Out_Qty IS SELECT plan_quantity plan_qty
41: FROM JAI_OPM_OSP_DTLS
42: WHERE osp_header_id = pr_new.batch_id and
43: issue_recpt_flag = 'R';
44: /*Commented by Brathod for Inv.Convergence, Cursor is not used anywhere in the code*/
45: