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.CSTPAPBR dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 239: FROM cst_cost_group_assignments

235: /* Get cost group of the transaction org */
236: BEGIN
237: SELECT NVL(cost_group_id, -1)
238: INTO l_txn_cost_group_id
239: FROM cst_cost_group_assignments
240: WHERE organization_id = l_ae_txn_rec.organization_id;
241: EXCEPTION
242: WHEN no_data_found THEN
243: l_txn_cost_group_id := -1;

Line 443: cst_cost_group_assignments

439: count(organization_id)
440: INTO
441: l_xfer_cg_exists
442: FROM
443: cst_cost_group_assignments
444: WHERE
445: organization_id = nvl(l_ae_txn_rec.xfer_organization_id,-1)
446: AND rownum < 2; /* bug 4586534 added rownum=1 for performance as its only existence check. */
447:

Line 456: cst_cost_group_assignments

452: DECODE (l_ae_txn_rec.xfer_organization_id,NULL,NULL,cost_group_id)
453: INTO
454: l_ae_txn_rec.xfer_cost_group_id
455: FROM
456: cst_cost_group_assignments
457: WHERE
458: organization_id = nvl(l_ae_txn_rec.xfer_organization_id,organization_id);
459: END IF;
460:

Line 660: FROM cst_cost_group_assignments

656:
657: BEGIN
658: SELECT NVL(cost_group_id, -1)
659: INTO l_txn_cost_group_id
660: FROM cst_cost_group_assignments
661: WHERE organization_id = i_ae_txn_rec.organization_id;
662: EXCEPTION
663: WHEN no_data_found THEN
664: l_txn_cost_group_id := -1;

Line 1988: FROM cst_cost_group_assignments

1984: cost group with the transfer transaction org cost group */
1985: BEGIN
1986: SELECT NVL(cost_group_id, -1)
1987: INTO l_txn_cost_group_id
1988: FROM cst_cost_group_assignments
1989: WHERE organization_id = i_ae_txn_rec.organization_id;
1990: EXCEPTION
1991: WHEN no_data_found THEN
1992: l_txn_cost_group_id := -1;

Line 2275: FROM cst_cost_group_assignments

2271: -- changed as a bug found during testing.
2272: BEGIN
2273: SELECT cost_group_id
2274: INTO l_shipping_cg_id
2275: FROM cst_cost_group_assignments
2276: WHERE organization_id = (SELECT decode(i_ae_txn_rec.txn_action_id,
2277: 21, organization_id,
2278: 22, organization_id, -- Logical Shipping txn
2279: 12, transfer_organization_id,

Line 2838: FROM cst_cost_group_assignments

2834: l_stmt_num := 102;
2835:
2836: SELECT NVL(MAX(cost_group_id),-1)
2837: INTO l_txfr_cost_group_id
2838: FROM cst_cost_group_assignments
2839: WHERE organization_id = i_ae_txn_rec.xfer_organization_id;
2840:
2841: l_stmt_num := 104;
2842:

Line 3655: FROM cst_cost_group_assignments

3651: l_stmt_num := 250;
3652:
3653: SELECT NVL(MAX(cost_group_id),-1)
3654: INTO l_txfr_cost_group_id
3655: FROM cst_cost_group_assignments
3656: WHERE organization_id = i_ae_txn_rec.xfer_organization_id;
3657:
3658: l_stmt_num := 255;
3659:

Line 4927: FROM cst_cost_group_assignments

4923: l_stmt_num := 465;
4924:
4925: SELECT NVL(MAX(cost_group_id),-1)
4926: INTO l_txfr_cost_group_id
4927: FROM cst_cost_group_assignments
4928: WHERE organization_id = i_ae_txn_rec.organization_id;
4929:
4930: l_stmt_num := 470;
4931:

Line 6641: FROM cst_cost_group_assignments CCGA

6637: mtl_pac_actual_cost_details MPACD
6638: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
6639: AND MMT.transaction_source_type_id = 2
6640: AND EXISTS (SELECT 1
6641: FROM cst_cost_group_assignments CCGA
6642: WHERE CCGA.cost_group_id = i_ae_txn_rec.cost_group_id
6643: AND CCGA.organization_id = MMT.organization_id)
6644: AND MMT.inventory_item_id = i_ae_txn_rec.inventory_item_id
6645: AND MMT.trx_source_line_id = l_ref_om_line_id

Line 8002: FROM cst_cost_group_assignments

7998: l_stmt_num := 5;
7999:
8000: SELECT NVL(cost_group_id, -1)
8001: INTO l_txn_cost_group_id
8002: FROM cst_cost_group_assignments
8003: WHERE organization_id = i_ae_txn_rec.organization_id;
8004: EXCEPTION
8005: WHEN no_data_found THEN
8006: l_txn_cost_group_id := -1;

Line 9464: FROM cst_cost_group_assignments

9460:
9461: BEGIN
9462: SELECT cost_group_id
9463: INTO l_shipping_cg_id
9464: FROM cst_cost_group_assignments
9465: WHERE organization_id = (SELECT decode(i_ae_txn_rec.txn_action_id,
9466: 21, organization_id,
9467: 22, organization_id, -- Logical Shipping txn
9468: 12, transfer_organization_id,

Line 9858: FROM cst_cost_group_assignments

9854: BEGIN
9855: l_stmt_num := 80;
9856: SELECT NVL(cost_group_id, -1)
9857: INTO l_txn_cost_group_id
9858: FROM cst_cost_group_assignments
9859: WHERE organization_id = i_ae_txn_rec.organization_id;
9860: EXCEPTION
9861: WHEN no_data_found THEN
9862: l_txn_cost_group_id := -1;

Line 10744: FROM cst_cost_group_assignments

10740: l_stmt_num := 130;
10741:
10742: SELECT NVL(MAX(cost_group_id),-1)
10743: INTO l_txfr_cost_group_id
10744: FROM cst_cost_group_assignments
10745: WHERE organization_id = i_ae_txn_rec.xfer_organization_id;
10746:
10747: l_stmt_num := 140;
10748: