APPS.CSTPAPBR dependencies on MTL_SECONDARY_INVENTORIES

Line 1135: FROM mtl_secondary_inventories

1131: OR MP.ORGANIZATION_ID = i_ae_txn_rec.organization_id;
1132: /* Get the expense sub or asset sub from the issue sub for logical exp req rcpt */
1133: SELECT decode(asset_inventory,1,0,1)
1134: INTO l_exp_sub
1135: FROM mtl_secondary_inventories
1136: WHERE secondary_inventory_name = i_ae_txn_rec.xfer_subinventory
1137: AND organization_id = i_ae_txn_rec.xfer_organization_id;
1138:
1139: IF ( l_exp_sub = 0

Line 1369: from mtl_secondary_inventories

1365: fnd_file.put_line(fnd_file.log,'Scrap txn: ');
1366: END IF;
1367: select decode(asset_inventory,1,0,1)
1368: into l_exp_sub
1369: from mtl_secondary_inventories
1370: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
1371: and organization_id = i_ae_txn_rec.organization_id;
1372:
1373: -- Transactions between expense subinventories and expense jobs are

Line 1620: from mtl_secondary_inventories

1616: l_stmt_num := 10;
1617:
1618: select decode(asset_inventory,1,0,1)
1619: into l_exp_sub1
1620: from mtl_secondary_inventories
1621: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
1622: and organization_id = i_ae_txn_rec.organization_id;
1623:
1624: l_stmt_num := 20;

Line 1627: from mtl_secondary_inventories

1623:
1624: l_stmt_num := 20;
1625: select decode(asset_inventory,1,0,1)
1626: into l_exp_sub2
1627: from mtl_secondary_inventories
1628: where secondary_inventory_name = i_ae_txn_rec.xfer_subinventory
1629: and organization_id = i_ae_txn_rec.organization_id;
1630:
1631: -- If expense to expense transfer or asset to asset then no accounting entries.

Line 1940: FROM mtl_secondary_inventories

1936: -- Treat it as asset subInv
1937: ELSE
1938: SELECT decode(asset_inventory,1,0,1)
1939: INTO l_exp_sub1
1940: FROM mtl_secondary_inventories
1941: WHERE secondary_inventory_name = i_ae_txn_rec.subinventory_code
1942: AND organization_id = i_ae_txn_rec.organization_id;
1943: END IF;
1944:

Line 2036: FROM mtl_secondary_inventories

2032: END IF;
2033:
2034: SELECT decode(asset_inventory,1,0,1)
2035: INTO l_exp_sub2
2036: FROM mtl_secondary_inventories
2037: WHERE secondary_inventory_name = i_ae_txn_rec.xfer_subinventory
2038: AND organization_id = i_ae_txn_rec.xfer_organization_id;
2039:
2040: IF (l_exp_sub1 = 0 AND l_exp_sub2 = 0) OR

Line 6509: from mtl_secondary_inventories

6505: l_stmt_num := 10;
6506:
6507: select decode(asset_inventory,1,0,1)
6508: into l_exp_sub
6509: from mtl_secondary_inventories
6510: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
6511: and organization_id = i_ae_txn_rec.organization_id;
6512:
6513: -- No accounting entries posted for any transaction involving an expense

Line 6921: from mtl_secondary_inventories

6917: if (i_ae_txn_rec.subinventory_code is not null) then
6918:
6919: select decode(asset_inventory,1,0,1)
6920: into l_exp_sub
6921: from mtl_secondary_inventories
6922: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
6923: and organization_id = i_ae_txn_rec.organization_id;
6924: else
6925: l_exp_sub := 0;

Line 8312: from mtl_secondary_inventories

8308: if (i_ae_txn_rec.txn_action_id = 3) then
8309: if (i_ae_txn_rec.cost_group_id = i_ae_txn_rec.xfer_cost_group_id) then
8310: select decode(asset_inventory,1,0,1)
8311: into l_exp_sub1
8312: from mtl_secondary_inventories
8313: where secondary_inventory_name = i_ae_txn_rec.subinventory_code
8314: and organization_id = i_ae_txn_rec.organization_id;
8315: if (l_exp_sub1 = 1) then
8316: l_ae_line_tbl(next_record_avail).reference2 := i_ae_txn_rec.xfer_organization_id;

Line 9809: FROM mtl_secondary_inventories

9805:
9806: /* Get the expense sub or asset sub from the issue sub for logical exp req rcpt */
9807: SELECT decode(asset_inventory,1,0,1)
9808: INTO l_exp_sub
9809: FROM mtl_secondary_inventories
9810: WHERE secondary_inventory_name = i_ae_txn_rec.xfer_subinventory
9811: AND organization_id = i_ae_txn_rec.xfer_organization_id;
9812:
9813: ELSE

Line 9819: FROM mtl_secondary_inventories

9815: l_stmt_num := 40;
9816:
9817: SELECT decode(asset_inventory,1,0,1)
9818: INTO l_exp_sub
9819: FROM mtl_secondary_inventories
9820: WHERE secondary_inventory_name = i_ae_txn_rec.subinventory_code
9821: AND organization_id = i_ae_txn_rec.organization_id;
9822:
9823: END IF;