APPS.CSTPAPBR dependencies on MTL_SECONDARY_INVENTORIES

Line 1151: from mtl_secondary_inventories

1147: fnd_file.put_line(fnd_file.log,'Scrap txn: ');
1148: END IF;
1149: select decode(asset_inventory,1,0,1)
1150: into l_exp_sub
1151: from mtl_secondary_inventories
1152: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
1153: and organization_id = i_ae_txn_rec.organization_id;
1154:
1155: -- Transactions between expense subinventories and expense jobs are

Line 1402: from mtl_secondary_inventories

1398: l_stmt_num := 10;
1399:
1400: select decode(asset_inventory,1,0,1)
1401: into l_exp_sub1
1402: from mtl_secondary_inventories
1403: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
1404: and organization_id = i_ae_txn_rec.organization_id;
1405:
1406: l_stmt_num := 20;

Line 1409: from mtl_secondary_inventories

1405:
1406: l_stmt_num := 20;
1407: select decode(asset_inventory,1,0,1)
1408: into l_exp_sub2
1409: from mtl_secondary_inventories
1410: where secondary_inventory_name = i_ae_txn_rec.xfer_subinventory
1411: and organization_id = i_ae_txn_rec.organization_id;
1412:
1413: -- If expense to expense transfer or asset to asset then no accounting entries.

Line 1720: FROM mtl_secondary_inventories

1716: -- Treat it as asset subInv
1717: ELSE
1718: SELECT decode(asset_inventory,1,0,1)
1719: INTO l_exp_sub1
1720: FROM mtl_secondary_inventories
1721: WHERE secondary_inventory_name = i_ae_txn_rec.subinventory_code
1722: AND organization_id = i_ae_txn_rec.organization_id;
1723: END IF;
1724:

Line 1816: FROM mtl_secondary_inventories

1812: END IF;
1813:
1814: SELECT decode(asset_inventory,1,0,1)
1815: INTO l_exp_sub2
1816: FROM mtl_secondary_inventories
1817: WHERE secondary_inventory_name = i_ae_txn_rec.xfer_subinventory
1818: AND organization_id = i_ae_txn_rec.xfer_organization_id;
1819:
1820: IF (l_exp_sub1 = 0 AND l_exp_sub2 = 0) OR

Line 6224: from mtl_secondary_inventories

6220: l_stmt_num := 10;
6221:
6222: select decode(asset_inventory,1,0,1)
6223: into l_exp_sub
6224: from mtl_secondary_inventories
6225: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
6226: and organization_id = i_ae_txn_rec.organization_id;
6227:
6228: -- No accounting entries posted for any transaction involving an expense

Line 6613: from mtl_secondary_inventories

6609: if (i_ae_txn_rec.subinventory_code is not null) then
6610:
6611: select decode(asset_inventory,1,0,1)
6612: into l_exp_sub
6613: from mtl_secondary_inventories
6614: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
6615: and organization_id = i_ae_txn_rec.organization_id;
6616: else
6617: l_exp_sub := 0;

Line 7929: from mtl_secondary_inventories

7925: if (i_ae_txn_rec.txn_action_id = 3) then
7926: if (i_ae_txn_rec.cost_group_id = i_ae_txn_rec.xfer_cost_group_id) then
7927: select decode(asset_inventory,1,0,1)
7928: into l_exp_sub1
7929: from mtl_secondary_inventories
7930: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
7931: and organization_id = i_ae_txn_rec.organization_id;
7932: if (l_exp_sub1 = 1) then
7933: l_ae_line_tbl(next_record_avail).reference2 := i_ae_txn_rec.xfer_organization_id;

Line 9373: FROM mtl_secondary_inventories

9369: l_stmt_num := 40;
9370:
9371: SELECT decode(asset_inventory,1,0,1)
9372: INTO l_exp_sub
9373: FROM mtl_secondary_inventories
9374: WHERE secondary_inventory_name = i_ae_txn_rec.subinventory_code
9375: AND organization_id = i_ae_txn_rec.organization_id;
9376:
9377: END IF;