eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_PO_SYNCH dependencies on IC_ITEM_MST

Line 430: FROM ic_item_mst

426: AND um_type = v_um_type;
427:
428: CURSOR item_cur IS
429: SELECT item_um
430: FROM ic_item_mst
431: WHERE item_id = v_item_id;
432:
433: v_std_factor1 NUMBER;
434: v_std_factor2 NUMBER;

Line 1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;

1490: v_line_id PO_ORDR_DTL.LINE_id%TYPE;
1491: v_new_line_id PO_ORDR_DTL.LINE_id%TYPE;
1492: v_line_no PO_ORDR_DTL.LINE_no%TYPE;
1493: v_dtl_line_no PO_ORDR_DTL.LINE_no%TYPE;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;

Line 1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;

1491: v_new_line_id PO_ORDR_DTL.LINE_id%TYPE;
1492: v_line_no PO_ORDR_DTL.LINE_no%TYPE;
1493: v_dtl_line_no PO_ORDR_DTL.LINE_no%TYPE;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

Line 1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */

1492: v_line_no PO_ORDR_DTL.LINE_no%TYPE;
1493: v_dtl_line_no PO_ORDR_DTL.LINE_no%TYPE;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;

Line 1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;

1493: v_dtl_line_no PO_ORDR_DTL.LINE_no%TYPE;
1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;

Line 1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;

1494: v_item_id IC_ITEM_MST.ITEM_ID%TYPE;
1495: v_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
1496: v_item_um1 IC_ITEM_MST.ITEM_UM%TYPE; /* PPB */
1497: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;
1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;

Line 1515: v_noninv_ind IC_ITEM_MST.NONINV_IND%TYPE;

1511: v_map_retcode NUMBER DEFAULT 0;
1512: uomcv_item_id NUMBER;
1513:
1514: /*PPB - Bug# 1365777 */
1515: v_noninv_ind IC_ITEM_MST.NONINV_IND%TYPE;
1516:
1517: v_old_po_status PO_ORDR_DTL.PO_STATUS%TYPE;
1518: v_old_cancellation_code PO_ORDR_DTL.CANCELLATION_CODE%TYPE;
1519:

Line 1597: CURSOR item_cur(v_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS

1593: WHERE po_header_id = v_po_header_id
1594: AND po_line_id = v_po_line_id
1595: AND po_line_location_id = v_po_line_location_id;
1596:
1597: CURSOR item_cur(v_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
1598: SELECT item_id, nvl(item_desc1,' '), item_um, item_um2, dualum_ind, noninv_ind
1599: FROM ic_item_mst
1600: WHERE item_no = v_item_no;
1601:

Line 1599: FROM ic_item_mst

1595: AND po_line_location_id = v_po_line_location_id;
1596:
1597: CURSOR item_cur(v_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
1598: SELECT item_id, nvl(item_desc1,' '), item_um, item_um2, dualum_ind, noninv_ind
1599: FROM ic_item_mst
1600: WHERE item_no = v_item_no;
1601:
1602: CURSOR co_code_cur(v_orgn_code SY_ORGN_MST.ORGN_CODE%TYPE) IS
1603: SELECT co_code

Line 1660: CURSOR item_dtl(v_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS

1656: AND line_id = v_line_id;
1657:
1658: rec_opm_po_line_dtl opm_po_line_dtl%ROWTYPE;
1659:
1660: CURSOR item_dtl(v_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
1661: SELECT item_id,item_um2
1662: FROM ic_item_mst
1663: WHERE item_no = v_item_no;
1664:

Line 1662: FROM ic_item_mst

1658: rec_opm_po_line_dtl opm_po_line_dtl%ROWTYPE;
1659:
1660: CURSOR item_dtl(v_item_no IC_ITEM_MST.ITEM_NO%TYPE) IS
1661: SELECT item_id,item_um2
1662: FROM ic_item_mst
1663: WHERE item_no = v_item_no;
1664:
1665: rec_item_dtl item_dtl%ROWTYPE;
1666: