APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_OM_OE_SO_LINES

Line 116: JAI_OM_OE_SO_LINES

112: IS
113: SELECT
114: lc_flag
115: FROM
116: JAI_OM_OE_SO_LINES
117: WHERE
118: lc_flag = 'Y' AND
119: header_id = pr_new.source_header_id;
120:

Line 153: JAI_OM_OE_SO_LINES

149: IS
150: SELECT
151: tax_amount
152: FROM
153: JAI_OM_OE_SO_LINES
154: WHERE
155: line_id = pr_new.source_line_id AND
156: header_id = pr_new.source_header_id;
157:

Line 183: JAI_OM_OE_SO_LINES a

179: a.line_number ,
180: a.shipment_line_number ,
181: quantity
182: FROM
183: JAI_OM_OE_SO_LINES a
184: WHERE
185: a.line_id = pr_new.source_line_id AND
186: a.header_id = pr_new.source_header_id ;
187:

Line 188: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;

184: WHERE
185: a.line_id = pr_new.source_line_id AND
186: a.header_id = pr_new.source_header_id ;
187:
188: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
189: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
190: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
191: v_quantity number;
192:

Line 189: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;

185: a.line_id = pr_new.source_line_id AND
186: a.header_id = pr_new.source_header_id ;
187:
188: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
189: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
190: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
191: v_quantity number;
192:
193: cursor c_orgn_info is

Line 190: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;

186: a.header_id = pr_new.source_header_id ;
187:
188: lv_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ;
189: ln_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ;
190: ln_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ;
191: v_quantity number;
192:
193: cursor c_orgn_info is
194: select trading

Line 502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;

498: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%TYPE;
499: v_basic_pla_balance NUMBER;
500: v_additional_pla_balance NUMBER;
501: v_other_pla_balance NUMBER;
502: ln_vat_assessable_value JAI_OM_OE_SO_LINES.VAT_ASSESSABLE_VALUE%TYPE;
503: lv_vat_exemption_flag JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_FLAG%TYPE;
504: lv_vat_exemption_type JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_TYPE%TYPE;
505: ld_vat_exemption_date JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_DATE%TYPE;
506: lv_vat_exemption_refno JAI_OM_WSH_LINES_ALL.VAT_EXEMPTION_REFNO%TYPE;

Line 525: FROM JAI_OM_OE_SO_LINES

521: AND organization_id = v_organization_id;
522:
523: CURSOR Get_So_Lines_Count_Cur IS
524: SELECT COUNT(*)
525: FROM JAI_OM_OE_SO_LINES
526: WHERE Line_id = v_source_line_id;
527:
528: CURSOR Get_So_Lines_Details_Cur IS
529: SELECT NVL(Selling_Price,0),

Line 541: FROM JAI_OM_OE_SO_LINES

537: vat_exemption_flag,
538: vat_exemption_type,
539: vat_exemption_date,
540: vat_exemption_refno
541: FROM JAI_OM_OE_SO_LINES
542: WHERE Line_id = v_source_line_id;
543:
544: CURSOR get_conv_detail_cur
545: IS

Line 2637: JAI_OM_OE_SO_LINES

2633: IS
2634: SELECT
2635: lc_flag
2636: FROM
2637: JAI_OM_OE_SO_LINES
2638: WHERE
2639: lc_flag = 'Y' AND
2640: header_id = pr_new.source_header_id;
2641:

Line 2714: FROM JAI_OM_OE_SO_LINES

2710: AND B.Delivery_Detail_id = v_delivery_detail_id;
2711:
2712: CURSOR Get_So_Lines_Count_Cur IS
2713: SELECT COUNT(*)
2714: FROM JAI_OM_OE_SO_LINES
2715: WHERE Line_id = v_source_line_id;
2716:
2717: CURSOR Get_So_Lines_Details_Cur IS
2718: SELECT NVL(Selling_Price,0),

Line 2730: FROM JAI_OM_OE_SO_LINES

2726: vat_exemption_flag,
2727: vat_exemption_type,
2728: vat_exemption_date,
2729: vat_exemption_refno
2730: FROM JAI_OM_OE_SO_LINES
2731: WHERE Line_id = v_source_line_id;
2732:
2733: BEGIN
2734: