APPS.FND_DOCUMENT_MANAGEMENT dependencies on FND_DM_NODES

Line 165: fnd_dm_nodes dmnode

161: p_product_function_id,
162: p_icon_name
163: FROM fnd_dm_product_function_syntax dmprod,
164: fnd_dm_functions dmfunc,
165: fnd_dm_nodes dmnode
166: WHERE dmnode.node_id = p_node_id
167: AND dmnode.product_id = dmprod.product_id
168: AND dmfunc.function_name = p_function_name
169: AND dmprod.function_id = dmfunc.function_id;

Line 341: FROM fnd_dm_nodes

337: ** get the product that is installed for that dm node
338: */
339: SELECT MAX(PRODUCT_ID)
340: INTO l_product_id
341: FROM fnd_dm_nodes
342: WHERE node_id = l_dm_node_id;
343:
344:
345: /*

Line 2842: FROM fnd_dm_nodes

2838: ** get the product that is installed for that dm node
2839: */
2840: SELECT MAX(PRODUCT_ID)
2841: INTO l_product_id
2842: FROM fnd_dm_nodes
2843: WHERE node_id = l_dm_node_id;
2844:
2845: /*
2846: ** get all the components of the document anchor

Line 3375: FROM fnd_dm_nodes;

3371: BEGIN
3372:
3373: SELECT MAX(node_id)
3374: INTO l_dm_node_id
3375: FROM fnd_dm_nodes;
3376:
3377: EXCEPTION
3378: /*
3379: ** If there are no rows defined then set the output variables

Line 3407: FROM fnd_dm_nodes

3403: ** was created by having a no data found exception handler.
3404: */
3405: SELECT node_id, node_name
3406: INTO dm_node_id, dm_node_name
3407: FROM fnd_dm_nodes
3408: WHERE node_id = l_dm_node_id;
3409:
3410: EXCEPTION
3411: /*

Line 3512: FROM fnd_dm_nodes

3508: ** get the product that is installed for that dm node
3509: */
3510: SELECT MAX(PRODUCT_ID)
3511: INTO l_product_id
3512: FROM fnd_dm_nodes
3513: WHERE node_id = TO_NUMBER(dm_node_id);
3514:
3515: IF (l_product_id = 1) THEN
3516:

Line 3585: from fnd_dm_nodes dmn, fnd_dm_products dmp

3581: dmn.product_id,
3582: dmp.product_name,
3583: dmp.vendor_name,
3584: dmp.version
3585: from fnd_dm_nodes dmn, fnd_dm_products dmp
3586: where dmn.product_id = dmp.product_id;
3587:
3588: rowcount number;
3589: att_tvalue varchar2(2000) default null;

Line 3793: from fnd_dm_nodes dmn, fnd_dm_products dmp

3789: dmn.product_id,
3790: dmp.product_name,
3791: dmp.vendor_name,
3792: dmp.version
3793: from fnd_dm_nodes dmn, fnd_dm_products dmp
3794: where dmn.product_id = dmp.product_id;
3795:
3796: begin
3797:

Line 4093: FROM fnd_dm_products dmp, fnd_dm_nodes dmn

4089: ** get the attributes
4090: */
4091: SELECT dmn.connect_syntax, dmp.product_name, dmn.product_id
4092: INTO l_connect_syntax, l_product_name, l_product_id
4093: FROM fnd_dm_products dmp, fnd_dm_nodes dmn
4094: WHERE dmn.node_id = l_dm_node_id
4095: AND dmp.product_id = dmn.product_id;
4096:
4097: IF (l_product_id = 10) THEN