APPS.GML_SYNCH_BPOS dependencies on IC_ITEM_MST

Line 322: /* Cursor to select values from ic_item_mst */

318: WHERE po_header_id = p_po_header_id
319: AND po_line_id = p_po_line_id
320: AND po_line_location_id = p_po_line_location_id;
321:
322: /* Cursor to select values from ic_item_mst */
323:
324: CURSOR item_cur (p_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
325: SELECT item_id, nvl(item_desc1,' '), item_um2, dualum_ind
326: FROM ic_item_mst

Line 324: CURSOR item_cur (p_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS

320: AND po_line_location_id = p_po_line_location_id;
321:
322: /* Cursor to select values from ic_item_mst */
323:
324: CURSOR item_cur (p_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
325: SELECT item_id, nvl(item_desc1,' '), item_um2, dualum_ind
326: FROM ic_item_mst
327: WHERE item_no = p_item_no;
328:

Line 326: FROM ic_item_mst

322: /* Cursor to select values from ic_item_mst */
323:
324: CURSOR item_cur (p_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
325: SELECT item_id, nvl(item_desc1,' '), item_um2, dualum_ind
326: FROM ic_item_mst
327: WHERE item_no = p_item_no;
328:
329: /* Cursor to select co_code */
330:

Line 345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;

341: v_bpo_line_id PO_BPOS_DTL.LINE_ID%TYPE;
342: v_new_line_id PO_BPOS_DTL.LINE_ID%TYPE;
343: v_bpo_line_no PO_BPOS_DTL.LINE_NO%TYPE;
344:
345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;
347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
348:
349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;

Line 346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;

342: v_new_line_id PO_BPOS_DTL.LINE_ID%TYPE;
343: v_bpo_line_no PO_BPOS_DTL.LINE_NO%TYPE;
344:
345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;
347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
348:
349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
350: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

Line 347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;

343: v_bpo_line_no PO_BPOS_DTL.LINE_NO%TYPE;
344:
345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;
347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
348:
349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
350: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
351: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

Line 349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;

345: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
346: v_item_um2 IC_ITEM_MST.ITEM_UM%TYPE;
347: v_item_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
348:
349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
350: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
351: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
352: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;
353: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;