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.PO_DOCUMENT_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1186: mtl_system_items_b MSI,

1182: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1183: FROM po_lines POL,
1184: po_line_types PLT,
1185: po_headers_all POHA,
1186: mtl_system_items_b MSI,
1187: financials_system_parameters FSP
1188: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1189: AND PLT.line_type_id = POL.line_type_id -- JOIN
1190: AND POHA.po_header_id(+) = POL.from_header_id -- JOIN

Line 1342: mtl_system_items_b MSI,

1338: --p_chg.shipment_changes.c_payment_type(i)
1339: FROM po_line_locations PLL,
1340: po_lines POL,
1341: po_line_types PLT,
1342: mtl_system_items_b MSI,
1343: financials_system_parameters FSP
1344: WHERE PLL.line_location_id =
1345: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment
1346: p_chg.shipment_changes.po_line_location_id(i) ) -- existing shipment

Line 1720: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/

1716: l_progress VARCHAR2(3) := '000';
1717:
1718: l_shipment_count NUMBER;
1719: l_return_status VARCHAR2(1);
1720: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1721: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1722: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1723: BEGIN
1724: IF (g_fnd_debug = 'Y') THEN

Line 1721: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */

1717:
1718: l_shipment_count NUMBER;
1719: l_return_status VARCHAR2(1);
1720: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1721: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1722: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1723: BEGIN
1724: IF (g_fnd_debug = 'Y') THEN
1725: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1722: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */

1718: l_shipment_count NUMBER;
1719: l_return_status VARCHAR2(1);
1720: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1721: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1722: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1723: BEGIN
1724: IF (g_fnd_debug = 'Y') THEN
1725: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1726: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

Line 1845: FROM mtl_system_items_b mtl,

1841: p_chg.shipment_changes.get_count = 0) THEN
1842:
1843: SELECT NVL(mtl.grade_control_flag,'N')
1844: INTO l_grade_control_flag
1845: FROM mtl_system_items_b mtl,
1846: financials_system_parameters fsp
1847: WHERE mtl.inventory_item_id = p_chg.line_changes.c_item_id(i)
1848: AND mtl.organization_id = fsp.inventory_organization_id;
1849:

Line 1869: FROM mtl_system_items_b msi,

1865:
1866: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1867: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1868: INTO l_dual_uom_ind,l_secondary_default_ind
1869: FROM mtl_system_items_b msi,
1870: financials_system_parameters fsp
1871: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1872: AND msi.organization_id = fsp.inventory_organization_id;
1873: ELSE

Line 1909: FROM mtl_system_items_b msi,

1905:
1906: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1907: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1908: INTO l_dual_uom_ind,l_secondary_default_ind
1909: FROM mtl_system_items_b msi,
1910: financials_system_parameters fsp
1911: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1912: AND msi.organization_id = fsp.inventory_organization_id;
1913: ELSE

Line 1987: FROM mtl_system_items

1983: IF ( p_chg.shipment_changes.preferred_grade(i) IS NOT NULL)
1984: AND (p_chg.shipment_changes.c_item_id(i) IS NOT NULL) THEN
1985:
1986: SELECT NVL(grade_control_flag,'N') INTO l_grade_control_flag
1987: FROM mtl_system_items
1988: WHERE inventory_item_id = p_chg.shipment_changes.c_item_id(i)
1989: AND organization_id = p_chg.shipment_changes.c_ship_to_organization_id(i) ;
1990:
1991: IF l_grade_control_flag = 'N' THEN

Line 3056: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

3052:
3053:
3054: l_return_status VARCHAR2(1);
3055: /* INVCONV sschinch 09/07/04 */
3056: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
3057: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch
3058: l_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3059: l_fsp_org_id NUMBER;
3060: x_count NUMBER;

Line 3057: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch

3053:
3054: l_return_status VARCHAR2(1);
3055: /* INVCONV sschinch 09/07/04 */
3056: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
3057: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch
3058: l_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3059: l_fsp_org_id NUMBER;
3060: x_count NUMBER;
3061: x_data VARCHAR2(100);

Line 3064: l_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;

3060: x_count NUMBER;
3061: x_data VARCHAR2(100);
3062: l_derived_sec_qty PO_LINE_LOCATIONS.quantity%TYPE;
3063: l_document_uom PO_LINES.secondary_unit_of_measure%TYPE;
3064: l_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;
3065: l_document_sec_uom PO_LINES.secondary_unit_of_measure%TYPE;
3066: l_new_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3067:
3068: l_new_amt NUMBER;

Line 3496: FROM mtl_system_items_b msi

3492:
3493: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3494: SELECT msi.tracking_quantity_ind,secondary_default_ind,secondary_uom_code
3495: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom
3496: FROM mtl_system_items_b msi
3497: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3498: AND msi.organization_id = l_fsp_org_id;
3499: ELSE
3500: l_dual_um_ind := 'P';

Line 3578: FROM mtl_system_items_b msi

3574:
3575: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3576: SELECT msi.tracking_quantity_ind,secondary_default_ind
3577: INTO l_dual_um_ind,l_secondary_default_ind
3578: FROM mtl_system_items_b msi
3579: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3580: AND msi.organization_id = l_fsp_org_id;
3581: ELSE
3582: l_dual_um_ind := 'P';

Line 3679: FROM mtl_system_items_b msi

3675:
3676: IF p_chg.shipment_changes.c_item_id(i) IS NOT NULL THEN
3677: SELECT msi.tracking_quantity_ind,secondary_default_ind
3678: INTO l_dual_um_ind,l_secondary_default_ind
3679: FROM mtl_system_items_b msi
3680: WHERE msi.inventory_item_id = p_chg.shipment_changes.c_item_id(i)
3681: AND msi.organization_id = l_fsp_org_id;
3682: ELSE
3683: l_secondary_default_ind := NULL;

Line 3891: l_item_number MTL_SYSTEM_ITEMS.segment1%TYPE;

3887: l_request_uom PO_LINES.unit_meas_lookup_code%TYPE;
3888: l_cur_uom PO_LINES.unit_meas_lookup_code%TYPE;
3889: l_request_uom2 PO_LINES.secondary_unit_of_measure%TYPE;
3890: l_cur_uom2 PO_LINES.secondary_unit_of_measure%TYPE;
3891: l_item_number MTL_SYSTEM_ITEMS.segment1%TYPE;
3892: l_qty2 PO_LINES.secondary_quantity%TYPE;
3893: l_opm_validate_ind VARCHAR2(1);
3894:
3895: l_last_msg_list_index NUMBER;