APPS.PO_WF_PO_CHARGE_ACC dependencies on MTL_SYSTEM_ITEMS

Line 237: from MTL_SYSTEM_ITEMS

233:
234: if (x_account is NULL) then -- Get expense account from Item Master
235: begin
236: select EXPENSE_ACCOUNT into x_account
237: from MTL_SYSTEM_ITEMS
238: where organization_id = x_dest_org_id
239: and inventory_item_id = x_item_id;
240:
241: exception

Line 398: from mtl_system_items

394: begin
395: x_progress := 'PO_WF_PO_CHARGE_ACC.check_inv_item_type: 01';
396:
397: select inventory_asset_flag into x_asset_item_flag
398: from mtl_system_items
399: where organization_id = x_dest_org_id
400: and inventory_item_id = x_item_id;
401:
402: /* Start DEBUG

Line 553: from MTL_SYSTEM_ITEMS

549: */
550: begin
551:
552: select EXPENSE_ACCOUNT into x_expense_acc
553: from MTL_SYSTEM_ITEMS
554: where organization_id = x_dest_org_id
555: and inventory_item_id = x_item_id;
556:
557: /*Bug 1319679

Line 1521: is_shopfloor_enabled_item MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;

1517: ---------------------------------------------------------------------------
1518: FUNCTION is_shopfloor_enabled_item(p_item_id IN NUMBER,
1519: p_inv_org_id IN NUMBER) RETURN BOOLEAN
1520: IS
1521: is_shopfloor_enabled_item MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
1522: BEGIN
1523: --SQL WHAT: Get the outside_operation_flag for a given item
1524: --SQL WHY: To find out if the item is Shopfloor enabled.
1525: SELECT outside_operation_flag -- it is a NOT NULL column

Line 1527: FROM MTL_SYSTEM_ITEMS

1523: --SQL WHAT: Get the outside_operation_flag for a given item
1524: --SQL WHY: To find out if the item is Shopfloor enabled.
1525: SELECT outside_operation_flag -- it is a NOT NULL column
1526: INTO is_shopfloor_enabled_item
1527: FROM MTL_SYSTEM_ITEMS
1528: WHERE inventory_item_id = p_item_id AND
1529: organization_id = p_inv_org_id;
1530:
1531: IF (is_shopfloor_enabled_item = 'Y') THEN

Line 1623: FROM MTL_SYSTEM_ITEMS

1619: -- Inventory Org for a Start OU for a given Transaction Flow.
1620: --SQL WHY: To default this as the PO Expense Account for SPS case
1621: SELECT expense_account
1622: INTO l_item_expense_account_id
1623: FROM MTL_SYSTEM_ITEMS
1624: WHERE organization_id = p_inv_org_id AND
1625: inventory_item_id = p_item_id;
1626:
1627: RETURN l_item_expense_account_id;