APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1620: -- logic to derive outsourced_assembly from mtl_system_items_b

1616: -----------------------------------------------------------------------
1617: --Start of Comments
1618: --Name: default_outsourced_assembly
1619: --Function:
1620: -- logic to derive outsourced_assembly from mtl_system_items_b
1621: -- in batch mode
1622: --Parameters:
1623: --IN:
1624: --p_item_id_tbl

Line 1947: -- default outsourced_assembly from mtl_system_items_b

1943: p_receipt_required_flag_tbl => x_line_locs.receipt_required_flag_tbl,
1944: x_accrue_on_receipt_flag_tbl => x_line_locs.accrue_on_receipt_flag_tbl
1945: );
1946:
1947: -- default outsourced_assembly from mtl_system_items_b
1948: default_outsourced_assembly
1949: (
1950: p_item_id_tbl => x_line_locs.ln_item_id_tbl,
1951: p_ship_to_organization_id_tbl => x_line_locs.ship_to_org_id_tbl,

Line 2355: FROM mtl_system_items

2351: INSERT INTO po_session_gt(key, num1, char1)
2352: SELECT p_key,
2353: p_index_tbl(i),
2354: inspection_required_flag
2355: FROM mtl_system_items
2356: WHERE p_item_id_tbl(i) IS NOT NULL
2357: AND x_inspection_required_flag_tbl(i) IS NULL
2358: AND inventory_item_id = p_item_id_tbl(i)
2359: AND organization_id = PO_PDOI_PARAMS.g_sys.def_inv_org_id;

Line 2555: FROM mtl_system_items

2551: SELECT p_key,
2552: p_index_tbl(i),
2553: invoice_close_tolerance,
2554: receive_close_tolerance
2555: FROM mtl_system_items
2556: WHERE p_item_id_tbl(i) IS NOT NULL
2557: AND (x_invoice_close_tolerance_tbl(i) IS NULL OR
2558: x_receive_close_tolerance_tbl(i) IS NULL)
2559: AND inventory_item_id = p_item_id_tbl(i)

Line 2600: FROM mtl_system_items

2596: SELECT p_key,
2597: p_index_tbl(i),
2598: invoice_close_tolerance,
2599: receive_close_tolerance
2600: FROM mtl_system_items
2601: WHERE p_item_id_tbl(i) IS NOT NULL
2602: AND (x_invoice_close_tolerance_tbl(i) IS NULL OR
2603: x_receive_close_tolerance_tbl(i) IS NULL)
2604: AND inventory_item_id = p_item_id_tbl(i)

Line 2897: FROM mtl_system_items

2893: SELECT p_key,
2894: p_index_tbl(i),
2895: outside_operation_flag,
2896: nvl(stock_enabled_flag,'N')
2897: FROM mtl_system_items
2898: WHERE p_item_id_tbl(i) IS NOT NULL
2899: AND x_accrue_on_receipt_flag_tbl(i) IS NULL
2900: AND inventory_item_id = p_item_id_tbl(i)
2901: AND organization_id = p_ship_to_org_id_tbl(i);

Line 3030: FROM mtl_system_items item,

3026: INSERT INTO po_session_gt(key, num1, char1)
3027: SELECT p_key,
3028: p_index_tbl(i),
3029: uom.unit_of_measure
3030: FROM mtl_system_items item,
3031: mtl_units_of_measure uom
3032: WHERE p_item_id_tbl(i) IS NOT NULL
3033: AND p_ship_to_org_id_tbl(i) IS NOT NULL
3034: AND x_secondary_unit_of_meas_tbl(i) IS NULL