DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on WIP_DISCRETE_JOBS

Line 1128: from wip_discrete_jobs

1124: l_acct_rec.res_account,
1125: l_acct_rec.osp_account,
1126: l_acct_rec.ovhd_account,
1127: l_acct_class
1128: from wip_discrete_jobs
1129: where organization_id = i_ae_txn_rec.organization_id
1130: and wip_entity_id = i_ae_txn_rec.txn_src_id;
1131: END IF;
1132:

Line 8194: FROM wip_discrete_jobs

8190: SELECT decode(l_cost_element, 1, nvl(material_account,-1),
8191: 3, nvl(resource_account, -1),
8192: 4, nvl(outside_processing_account, -1), -1)
8193: INTO l_ae_line_rec.account
8194: FROM wip_discrete_jobs
8195: WHERE wip_entity_id = l_ae_line_rec.wip_entity_id;
8196:
8197: /* Set Debit Flag properly.
8198: -- ------------------------ */

Line 8565: from wip_discrete_jobs

8561: -- ------------------------------------------------------------------------------------------------
8562: l_stmt_num := 40;
8563: select count(wip_entity_id) /* Changed for Bug No. 4586534 */
8564: into l_acct_exist
8565: from wip_discrete_jobs
8566: where wip_entity_id = l_wip_entity_id;
8567:
8568: if (l_acct_exist = 0) then
8569: raise no_dj_acct_error;

Line 8590: from wip_discrete_jobs

8586: 5, nvl(overhead_variance_account,-1)),
8587: o_acct_id2)
8588: into o_acct_id1,
8589: o_acct_id2
8590: from wip_discrete_jobs
8591: where wip_entity_id = l_wip_entity_id;
8592: elsif l_entity_type = 2 then
8593:
8594: -- Get Elemental Accounts from WRS.

Line 8871: -- If Job type is Discrete then get from table WIP_DISCRETE_JOBS

8867: l_stmt_num := 58;
8868: -------------------------------------------------------------------------
8869: -- Get the Variance Accounts based Job type
8870: -- If Job type is Repetitive then get from table WIP_REPETITIVE_SCHEDULES
8871: -- If Job type is Discrete then get from table WIP_DISCRETE_JOBS
8872: -------------------------------------------------------------------------
8873: IF (i_ae_txn_rec.wip_entity_type = 1) THEN
8874:
8875: SELECT decode(cost_element, 1, material_variance_account,

Line 8881: FROM WIP_DISCRETE_JOBS

8877: 3, resource_variance_account,
8878: 4, outside_proc_variance_account,
8879: 5, overhead_variance_account)
8880: INTO l_ae_line_rec.account
8881: FROM WIP_DISCRETE_JOBS
8882: WHERE organization_id = i_ae_txn_rec.organization_id
8883: AND wip_entity_id = i_ae_txn_rec.txn_src_id;
8884: ELSE
8885: SELECT decode(cost_element, 1, material_variance_account,