DBA Data[Home] [Help]

APPS.CST_UTILITY_PUB dependencies on WIP_DISCRETE_JOBS

Line 849: -- issue_zero_cost_flag in wip_discrete_jobs of the work order; --

845: -- inventory item is an asset item --
846: -- entity_type of wip_entity_id = 6, 7 --
847: -- If any of these conditions are not passed, then return 0 --
848: -- After checking that all these conditions pass, then check the --
849: -- issue_zero_cost_flag in wip_discrete_jobs of the work order; --
850: -- return the value of the flag --
851: -- --
852: -- PARAMETERS --
853: -- P_API_VERSION API Version # - REQUIRED: enter 1.0 --

Line 1052: from wip_discrete_jobs

1048: ---------------------------------------------
1049: l_statement := 110;
1050: select decode(nvl(issue_zero_cost_flag, 'N'), 'Y', 1, 0)
1051: into l_zero_cost_flag
1052: from wip_discrete_jobs
1053: where wip_entity_id = l_wip_entity_id;
1054:
1055: x_zero_cost_flag := l_zero_cost_flag;
1056:

Line 1221: from wip_discrete_jobs

1217: select decode(l_cst_element_id, 1, nvl(material_account,-1),
1218: 3, nvl(resource_account, -1),
1219: 4, nvl(outside_processing_account, -1))
1220: into l_account
1221: from wip_discrete_jobs
1222: where wip_entity_id = p_wip_entity_id;
1223: end if;
1224:
1225: x_material_acct := l_account;